> I always wondered why the function to simply eliminate duplicate > records is hidden within the SUM function? This is awkward. Why > isn't there a clear and straight forward keyword either on the > OPTION or on the SORT statement, such as NODUPLICATES/DUPLICATES? >
Peter, With DFSORT it is not hidden but you need to use the ICETOOL operator SELECT to filter duplicates or get duplicates. SELECT operator offers wide range of features in addition to dups. Check this link which explains in detail https://www.ibm.com/support/knowledgecenter/en/SSLTBW_2.3.0/com.ibm.zos.v2r3.icea100/icesel.htm SELECT operator by default uses EQUALS and OP is using the max sorting fields and hence he needs to use SUM FIELDS=NONE with option NOEQUALS Further if you have any questions, please let me know Thanks, Kolusu DFSORT Development IBM Corporation IBM Mainframe Discussion List <[email protected]> wrote on 09/19/2017 09:34:47 PM: > From: Peter Hunkeler <[email protected]> > To: [email protected] > Date: 09/19/2017 09:35 PM > Subject: Eliminating duplicates (was: z/os 2.2 - help with sort/icetool) > Sent by: IBM Mainframe Discussion List <[email protected]> > > >//TOOLCNTL DD * > >OPTION NOEQUALS,DYNALLOC=(SYSDA,8) > >SORT FIELDS=(104,4088,A),FORMAT=CH > >SUM FIELDS=NONE > >//* > > > I always wondered why the function to simply eliminate duplicate > records is hidden within the SUM function? This is awkward. Why > isn't there a clear and straight forward keyword either on the > OPTION or on the SORT statement, such as NODUPLICATES/DUPLICATES? > > > -- > Peter Hunkeler > > > > > ---------------------------------------------------------------------- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to [email protected] with the message: INFO IBM-MAIN > ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
