> -----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