I am comparing two files File with LRECL = 154 File2 with LRECL =19
Keys in the File1 = 4,9 Keys in File2 = 1,9
I used follwoing SORTCARD for the task but the output is not as expected, please suggest me or correct me with your inputs.
OPTION COPY
JOINKEYS FILES=F1,FIELDS=(4,9,A)
JOINKEYS FILES=F2,FIELDS=(1,9,A)
JOIN UNPAIRED
REFORMAT FIELDS=(F1:01,154,F2:01,19)
OUTFIL FNAMES=MTCH01,
INCLUDE=(1,1,CH,NE,C' ',AND,155,1,CH,NE,C' '),
BUILD=(1,154)
OUTFIL FNAMES=UNMTCH01,
INCLUDE=(1,1,CH,NE,C' ',AND,155,1,CH,EQ,C' '),
BUILD=(1,154)
OUTFIL FNAMES=UNMTCH02,
INCLUDE=(1,1,CH,EQ,C' ',AND,155,1,CH,NE,C' '),
BUILD=(155,19)
JOINKEYS FILES=F1,FIELDS=(4,9,A)
JOINKEYS FILES=F2,FIELDS=(1,9,A)
JOIN UNPAIRED
REFORMAT FIELDS=(F1:01,154,F2:01,19)
OUTFIL FNAMES=MTCH01,
INCLUDE=(1,1,CH,NE,C' ',AND,155,1,CH,NE,C' '),
BUILD=(1,154)
OUTFIL FNAMES=UNMTCH01,
INCLUDE=(1,1,CH,NE,C' ',AND,155,1,CH,EQ,C' '),
BUILD=(1,154)
OUTFIL FNAMES=UNMTCH02,
INCLUDE=(1,1,CH,EQ,C' ',AND,155,1,CH,NE,C' '),
BUILD=(155,19)
) and someone would have to verify this solution but i think the problem may be in the INCLUDE statement