>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
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
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
>//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
>
> To: IBM-MAIN@LISTSERV.UA.EDU
> Date: 09/19/2017 04:23 PM
> Subject: Re: z/os 2.2 - help with sort/icetool
> Sent by: IBM Mainframe Discussion List <IBM-MAIN@LISTSERV.UA.EDU>
>
> My goal is to delete any dups - so getting this far was just the first
step
>
> Chris Hoelsche
Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf
Of David Betten
Sent: Tuesday, September 19, 2017 6:16 PM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: [IBM-MAIN] z/os 2.2 - help with sort/icetool
Glad it worked. Just to be clear, EQUALS is specified if you want to maintain
.EDU
> Date: 09/19/2017 06:02 PM
> Subject: Re: z/os 2.2 - help with sort/icetool
> Sent by: IBM Mainframe Discussion List <IBM-MAIN@LISTSERV.UA.EDU>
>
> NOEQUALS made it work - thanks to all
>
> Chris Hoelscher
> Technology Architect, Database Infrastructure Services
-MAIN@LISTSERV.UA.EDU] On Behalf
Of David Betten
Sent: Tuesday, September 19, 2017 5:40 PM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: [IBM-MAIN] z/os 2.2 - help with sort/icetool
Is it possible your installation default is EQUALS=YES? This causes extra
bytes to be added to the sort field internally
...@us.ibm.com
IBM Mainframe Discussion List <IBM-MAIN@LISTSERV.UA.EDU> wrote on
09/19/2017 05:20:05 PM:
> From: Chris Hoelscher <choelsc...@humana.com>
> To: IBM-MAIN@LISTSERV.UA.EDU
> Date: 09/19/2017 05:20 PM
> Subject: Re: z/os 2.2 - help with sort/icetool
> Sent by: IB
ilto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf
Of Elardus Engelbrecht
Sent: Tuesday, September 19, 2017 5:03 PM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: [IBM-MAIN] z/os 2.2 - help with sort/icetool
Chris Hoelscher wrote:
>//IN DD DSN=&UNIQSTOK,
>//
Chris Hoelscher wrote:
>//IN DD DSN=&UNIQSTOK,
>// DISP=(OLD,DELETE)
...
> SORT FIELDS=(104,4088,A),FORMAT=CH
...
> ICE201I A RECORD TYPE IS F - DATA STARTS IN POSITION 1
>
Is that RECFM correct?
>
I *have* read the manual, but am apparently still clueless
The jcl
//STEP45 EXEC PGM=ICETOOL,REGION=0M
//IN DD DSN=&,
// DISP=(OLD,DELETE)
//OUT DD SYSOUT=X,LRECL=25600
//TOOLIN DD *
12 matches
Mail list logo