SUM FIELDS = NONE in JOINKEY Operation
Posted: Fri Jun 22, 2012 4:16 pm
Hi,
Good Day.
My objective is to compare two files and get the unpaired F2 data. (if F2 does have duplicates or the content are in both files duplicates then it should be removed) . I am using DFSORT and using JOINKEY operations. Please find my code below.
JOINKEYS FILES=F1,FIELDS=(23,18,A,42,9,A,63,17,A)
JOINKEYS FILES=F2,FIELDS=(23,18,A,42,9,A,63,17,A)
JOIN UNPAIRED,F2,ONLY
REFORMAT FIELDS(F2:1,186)
SUM FIELDS=NONE
OPTION COPY
My second input file does contain duplicates also contains the records which is there in first input file. when i am using the above code, duplicates are not eliminated from the file.
Could some one please help..
can i use some code to elimate in JNF2CNTL ...
Good Day.
My objective is to compare two files and get the unpaired F2 data. (if F2 does have duplicates or the content are in both files duplicates then it should be removed) . I am using DFSORT and using JOINKEY operations. Please find my code below.
JOINKEYS FILES=F1,FIELDS=(23,18,A,42,9,A,63,17,A)
JOINKEYS FILES=F2,FIELDS=(23,18,A,42,9,A,63,17,A)
JOIN UNPAIRED,F2,ONLY
REFORMAT FIELDS(F2:1,186)
SUM FIELDS=NONE
OPTION COPY
My second input file does contain duplicates also contains the records which is there in first input file. when i am using the above code, duplicates are not eliminated from the file.
Could some one please help..
can i use some code to elimate in JNF2CNTL ...