HEADER3 usage in DFSORT



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

HEADER3 usage in DFSORT

Postby PREM_G » Tue Dec 02, 2014 7:58 pm

Hi,
First time I have registered to this forum .My "hai" to all .Below is my question .
I would like to know the dfsort card for header3 usage for below situation
My requirement
INPUT FILE :
A000110000
A000110000
A000110000
C000120000
C000120000
B000130000
B000130000
B000130000
B000130000
B000130000

O/P FILE SHOULD BE LIKE THIS
A000130000
A000110000
A000110000
B0001150000
B000130000
B000130000
B000130000
B000130000
C000140000
C000120000
which MEANS ,I need to total the record amounts based on Key (a0001,b0001,c0001) and put the Total on the first record (header record) of the corresponding key .I tried below sort card .Actually I am not sure how it works I used google to write this .Kindly correct the below sort card .Thanks a lot in advance .
SORT FIELDS=(1,5,A),FORMAT=CH
OUTFIL FNAMES=SORTOUT,
SECTIONS=(1,5,SKIP=P,
HEADER3=(6:TOTAL=(6,5,ZD,M5,LENGTH=10)))

Prem
PREM_G
 
Posts: 1
Joined: Tue Dec 02, 2014 5:58 pm
Has thanked: 0 time
Been thanked: 0 time

Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post