Combining two different records in same file
Posted: Thu Dec 29, 2011 12:20 am
Hi,
Intention is to combine contents of two records into 1 present in the same file
Combine Record#1 & Record#2 into 1 similarly Record#3 & Record#4 into 1
I was trying to use the WHEN=GROUP by labelling every two records and then use SPLICE
INREC IFTHEN=(WHEN=GROUP,RECORDS=2,PUSH=(15:ID=3,19:SEQ=2))
Our shop uses SYNCSORT FOR Z/OS 1.3.0.2R which is not the latest version of SYNCSORT hence unable to use the WHEN=GROUP
Below is the input and intended output.
Input
Output
Intention is to combine contents of two records into 1 present in the same file
Combine Record#1 & Record#2 into 1 similarly Record#3 & Record#4 into 1
I was trying to use the WHEN=GROUP by labelling every two records and then use SPLICE
INREC IFTHEN=(WHEN=GROUP,RECORDS=2,PUSH=(15:ID=3,19:SEQ=2))
Our shop uses SYNCSORT FOR Z/OS 1.3.0.2R which is not the latest version of SYNCSORT hence unable to use the WHEN=GROUP
Below is the input and intended output.
Input
NO OF PTA RECORDS WRITTEN :000000022
1 //TT@7NA00 JOB (1111,,TT,999999),'TEMP JOB DLY',
NO OF PTA RECORDS WRITTEN :000000124
1 //TT@7NA01 JOB (1111,,TT,999999),'TEMP JOB',
1 //TT@7NA02 JOB (1111,,TT,999999),'TEMP JOB',
NO OF PTA RECORDS WRITTEN :000000116
NO OF PTA RECORDS WRITTEN :000000103
1 //TT@7NA03 JOB (1111,,TT,999999),'TEMP JOB',
1 //TT@7NA04 JOB (1111,,TT,999999),'TEMP JOB',
NO OF PTA RECORDS WRITTEN :000000098
1 //TT@7NA00 JOB (1111,,TT,999999),'TEMP JOB DLY',
NO OF PTA RECORDS WRITTEN :000000124
1 //TT@7NA01 JOB (1111,,TT,999999),'TEMP JOB',
1 //TT@7NA02 JOB (1111,,TT,999999),'TEMP JOB',
NO OF PTA RECORDS WRITTEN :000000116
NO OF PTA RECORDS WRITTEN :000000103
1 //TT@7NA03 JOB (1111,,TT,999999),'TEMP JOB',
1 //TT@7NA04 JOB (1111,,TT,999999),'TEMP JOB',
NO OF PTA RECORDS WRITTEN :000000098
Output
TT@7NA00 NO OF PTA RECORDS WRITTEN :000000022
TT@7NA01 NO OF PTA RECORDS WRITTEN :000000124
TT@7NA02 NO OF PTA RECORDS WRITTEN :000000116
TT@7NA03 NO OF PTA RECORDS WRITTEN :000000103
TT@7NA04 NO OF PTA RECORDS WRITTEN :000000098
TT@7NA01 NO OF PTA RECORDS WRITTEN :000000124
TT@7NA02 NO OF PTA RECORDS WRITTEN :000000116
TT@7NA03 NO OF PTA RECORDS WRITTEN :000000103
TT@7NA04 NO OF PTA RECORDS WRITTEN :000000098