dipsybaby
New User
Joined: 18 Mar 2005 Posts: 9
|
|
|
|
Hi,
I am trying to do a match using SYNCSORT and only in case if 22,2,ch,eq,c'9A' we need to overlay with records from other portion.
Also we need both matched and unmatced records in seperate file.
Code: |
JOINKEYS FILES=F1,FIELDS=(1,17,A)
JOINKEYS FILES=F2,FIELDS=(1,17,A),INCLUDE=(22,2,CH,EQ,C'1A')
REFORMAT FIELDS=(F1:1,255,F2:1,255),FILL=X'FF'
JOIN UNPAIRED
SORT FIELDS=COPY
OUTFIL FILES=01,INCLUDE=(1,1,BI,NE,X'FF',AND,256,1,BI,NE,X'FF'),
OUTREC IFTHEN=(WHEN=(22,2,CH,EQ,C'9A'),
BUILD=(1,43,44:364,10,54:305,8,62,193)),
IFTHEN=(WHEN=NONE,
BUILD=(1,255))
OUTFIL FILES=02,INCLUDE=(256,1,BI,EQ,X'FF'),OUTREC=(1,255) |
I am using SYNCSORT FOR Z/OS 1.3.2.0R.
I believe from the error message I am getting, that IFTHEN is not supported by this version of SYNCSORT.
Any help to achieve the above logic would be helpful.
Thanks,
Dipsy |
|