AW: Re: Eliminating duplicates (was: z/os 2.2 - help with sort/icetool)

2017-09-20 Thread Peter Hunkeler
>I'd say it's because eliminating duplicate records isn't really a core feature; it's just a useful by-product of the SUM function. I'd answer DFSORT has a lot of features which I would not consider core features, which doesn't mean they are not useful. >Obviously, there's a world of divers

Re: Eliminating duplicates (was: z/os 2.2 - help with sort/icetool)

2017-09-20 Thread Steve Smith
I'd say it's because eliminating duplicate records isn't really a core feature; it's just a useful by-product of the SUM function. Obviously, there's a world of divers requirements out there, but SORT focuses on cases where you want to combine information from duplicate keys, not just ignore

Re: Eliminating duplicates (was: z/os 2.2 - help with sort/icetool)

2017-09-20 Thread Sri h Kolusu
ssion List <IBM-MAIN@LISTSERV.UA.EDU> wrote on 09/19/2017 09:34:47 PM: > From: Peter Hunkeler <p...@gmx.ch> > To: IBM-MAIN@LISTSERV.UA.EDU > Date: 09/19/2017 09:35 PM > Subject: Eliminating duplicates (was: z/os 2.2 - help with sort/icetool) > Sent by: IBM Mainframe

Eliminating duplicates (was: z/os 2.2 - help with sort/icetool)

2017-09-19 Thread Peter Hunkeler
>//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