JCL syncsort using Joinkeys to compare two files.
Posted: Sat Jan 16, 2016 12:46 pm
I need help to write JCL syncsort using Joinkeys to compare two files.
I want to eliminate records from File1 depending on File2:-
1. First 9bytes of File1 will match with the First 9bytes of the FIle2.If not matched,it should not be present in the output file.
2.9th byte can be space in the both file.
File1:
CFEISEAA1HELLO
CFEISEBB1HI
CEEISEZZ MODI
File2:
CFEISEBB1
CEEISEZZ+(SPACE)
Output File:
CFEISEBB1HI
CEEISEZZ MODI
Kaushik_2016
I want to eliminate records from File1 depending on File2:-
1. First 9bytes of File1 will match with the First 9bytes of the FIle2.If not matched,it should not be present in the output file.
2.9th byte can be space in the both file.
File1:
CFEISEAA1HELLO
CFEISEBB1HI
CEEISEZZ MODI
File2:
CFEISEBB1
CEEISEZZ+(SPACE)
Output File:
CFEISEBB1HI
CEEISEZZ MODI
Kaushik_2016