Raghuraman_New
New User
Joined: 03 Oct 2008
Posts: 43
Location: Chennai,India.
|
|
|
|
Hi,
My Input data,
Key1 Data1
Key1 Data2
Key2 Data3
Key2 Data4
Key3 Data5
Key3 Data6
Key4 Data7
Key4 Data8
Required Output,
Key1 Data1 Data2
Key2 Data3 Data4
Key3 Data5 Data6
Key4 Data7 Data8 |
|
Alissa Margulies
SYNCSORT Support
Joined: 25 Jul 2007
Posts: 496
Location: USA
|
|
|
|
Based on the sample data you provided, here is a SyncSort for z/OS 1.2 application that should produce the desired output:
| Code: |
//SORT1 EXEC PGM=SORT
//SYSOUT DD SYSOUT=*
//SORTIN DD *
KEY1 DATA1
KEY1 DATA2
KEY2 DATA3
KEY2 DATA4
KEY3 DATA5
KEY3 DATA6
KEY4 DATA7
KEY4 DATA8
//SORTOUT DD SYSOUT=*
//SYSIN DD *
INREC IFTHEN=(WHEN=INIT,
OVERLAY=(81:SEQNUM,1,ZD,RESTART=(1,4))),
IFTHEN=(WHEN=(81,1,ZD,EQ,1),
BUILD=(1:1,11,12:6Z)),
IFTHEN=(WHEN=(81,1,ZD,EQ,2),
BUILD=(1:1,5,6:6Z,12:6,5,1Z))
SORT FIELDS=(1,4,CH,A)
SUM FIELDS=(6,4,BI,10,4,BI,14,4,BI)
/* |
|
|
