> -----Original Message-----
> From: IBM Mainframe Discussion List 
> [mailto:[EMAIL PROTECTED] On Behalf Of Dave Kopischke
> Sent: Tuesday, January 15, 2008 11:00 AM
> To: IBM-MAIN@BAMA.UA.EDU
> Subject: Re: DFSORT question MERGE w/SUM FIELDS=NONE
> 
> 
> On Tue, 15 Jan 2008 10:25:23 -0600, McKown, John wrote:
> 
> >The manual is unclear on this. First question: Is this 
> supported? I.e.
> >will SORTOUT contain only one of the records with the duplicate key?
> >Second question: Which record will be kept? Random, the one read from
> >the lowest SORTINnn or the one read from the highest SORTINnn DD
> >statement?
> >
> 
> We use SYNCSORT...
> 
> There's a parameter called EQUALS that ensures the first 
> duplicate is the one 
> that will show up on a deduped SORTed/MERGEd file. Does 
> DFSORT have an 
> equivalent ???

Yes, I just didn't really see how EQUALS applies to a MERGE. Possibly
just lact of understanding on my part. I do understand how EQUALS
applies to SORT since SORT is only reading one input file, so which is
"first" makes sense to me. But MERGE is reading records from multiple
input files, so which is "first"? The first one actually read? (that
would be random, depending on the data in the various input files) Or
the one which is read from the lowest numbered SORTINnn? In the words of
Vinnie Barbarino "I'm so confused!"

--
John McKown
Senior Systems Programmer
HealthMarkets
Keeping the Promise of Affordable Coverage
Administrative Services Group
Information Technology

The information contained in this e-mail message may be privileged
and/or confidential.  It is for intended addressee(s) only.  If you are
not the intended recipient, you are hereby notified that any disclosure,
reproduction, distribution or other use of this communication is
strictly prohibited and could, in certain circumstances, be a criminal
offense.  If you have received this e-mail in error, please notify the
sender by reply and delete this message without copying or disclosing
it. 

----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html

Reply via email to