If NOEQUALS is in effect, the record which is retained is determined arbitrarily. If EQUALS is in effect, the record which is retained is the first record read. In a MERGE application the retained record will be from the lowest numbered input file.
These rules should hold true for SyncSort, DFSORT or CA-Sort. -----Original Message----- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Dave Kopischke Sent: Tuesday, January 15, 2008 12:00 PM 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 ??? ---------------------------------------------------------------------- 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