Rahul Reddy R
New User
Joined: 01 Apr 2008
Posts: 4
Location: Mysore
|
|
|
|
I need a JCL/Utility which returns the count for each key in a flat file.
Eg:
If the file has dept, vend and clr as fields and the data goes like this...
dept vend clr
220 336 100
220 336 120
220 336 250
220 450 500
220 450 850
360 254 120
360 254 560
360 254 720
360 265 560
The output should be the count based on dept and vend. i.e., as given below
dept vend count
220 336 3
220 450 2
360 254 3
360 265 1
Is there any way to get this result through a JCL/Utility instead of a program.
Thanks in Advance....
Rahul |
|
Escapa
Senior Member
Joined: 16 Feb 2007
Posts: 1399
Location: IL, USA
|
|
|
|
How about using sort utility for it.. (Assuming input LRECL=11)
| Code: |
//S1 EXEC PGM=SORT
//SORTIN DD *
220 336 100
220 336 120
220 336 250
220 450 500
220 450 850
360 254 120
360 254 560
360 254 720
360 265 560
//SORTOUT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSIN DD *
SORT FIELDS=(1,3,CH,A,5,3,CH,A)
SUM FIELDS=(12,8,ZD)
INREC BUILD=(1,11,C'00000001')
OUTREC BUILD=(1,8,12,8)
/*
|
Output will be
| Code: |
220 336 00000003
220 450 00000002
360 254 00000003
360 265 00000001
|
|
|
