SORT or ICETOOL to merger 2 80 byte records.



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

Re: SORT or ICETOOL to merger 2 80 byte records.

Postby NicC » Tue Jul 31, 2018 2:07 pm

No, Enrico's example is straight from the DFSort Tricks. It causes sort to read as many records as needed to fill the output LRECL (TOLEN), concatenate them together and write them out as one record. In fact, from the DFSort Tricks manual:
Here's a DFSORT/ICETOOL job to combine each group of 3 records into one long record.
//COMB1 EXEC PGM=ICETOOL
//TOOLMSG DD SYSOUT=*
//DFSMSG DD SYSOUT=*
//IN1 DD DSN=... input file (FB/10)
//OUT1 DD DSN=... output file (FB/30)
//TOOLIN DD *
RESIZE FROM(IN1) TO(OUT1) TOLEN(30)
TOLEN(30) indicates an output length of 30. RESIZE automatically resizes each group of 10-byte input records to
a 30-byte output record.
All you need to know to use RESIZE is the input length and the desired output length
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic

These users thanked the author NicC for the post:
rahulkrddd (Tue Jul 31, 2018 5:12 pm)
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times

Previous

Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post