er_vinodh
New User
Joined: 08 Jul 2005 Posts: 3 Location: Chennai
|
|
|
|
hi all
I have a requirement to sort data of two different columns, which have similar data and must be sorted together as a single field.
eg: Input file
Code: |
user field1_emp...... fieldn_emp
1-10 11-18 51-58
--------------------------------------
aaaa 00111222
bbbb 00111555
aaaa 00111333
aaaa 00111222
aaaa 00111666
cccc 00111444
|
Output file must be like (first sort it in user, then field 1 and fieldn in same level) :
Code: |
user field1_emp...... fieldn_emp
1-10 11-18 51-58
--------------------------------------
aaaa 00111222
aaaa 00111222
aaaa 00111333
aaaa 00111666
bbbb 00111555
cccc 00111444
|
thanks |
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
You can use a DFSORT job like this to do what you want:
Code: |
//S1 EXEC PGM=ICEMAN
//SYSOUT DD SYSOUT=*
//SORTIN DD *
aaaa 00111222
bbbb 00111555
aaaa 00111333
aaaa 00111222
aaaa 00111666
cccc 00111444
//SORTOUT DD SYSOUT=*
//SYSIN DD *
INREC IFTHEN=(WHEN=INIT,OVERLAY=(81:11,8)),
IFTHEN=(WHEN=(11,8,CH,EQ,C' '),OVERLAY=(81:51,8))
OPTION EQUALS
SORT FIELDS=(1,10,CH,A,81,8,CH,A)
OUTREC BUILD=(1,80)
|
SORTOUT will have:
Code: |
aaaa 00111222
aaaa 00111222
aaaa 00111333
aaaa 00111666
bbbb 00111555
cccc 00111444
|
|
|