Join in DFSORT

PalDesh22 · New User Joined: 11 Nov 2010 Posts: 2 Location: India

I have 2 files. ABCD and WXYZ.
I want to compare the records on some fields and those records not matching should go back to ABCD adn WXYZ
JOINKEYS FILES=F1,FIELDS=(06,08,A,15,09,A,25,01,A,32,11,A,44,13,A)
JOINKEYS FILES=F2,FIELDS=(06,08,A,15,09,A,25,01,A,32,11,A,44,13,A)
REFORMAT FIELDS=(F1:1,100)
JOIN UNPAIRED,ONLY
OPTION COPY
OUTFIL FNAMES=SORTOF01,INCLUDE=(1,4,CH,EQ,C'ABCD'),
BUILD=(1,100)
OUTFIL FNAMES=SORTOF02,INCLUDE=(1,4,CH,EQ,C'WXYZ'),
BUILD=(1,100)

All the unmatch records from ABCD are coming fine.. but, WXYZ is coming blank.

sqlcode1 · Active Member Joined: 08 Apr 2010 Posts: 577 Location: USA

PalDesh22,
Check your REFORMAT FIELDS=(F1:1,100) statement, are you selecting anything from F2?

Thanks,

Skolusu · Posted: Tue Apr 19, 2011 9:40 pm

PalDesh22,

As SQLCODE1 mentioned you need to code the fields from file 2 also on the REFORMAT statement.

Use the following control cards