Syncsort Join
Posted: Thu Nov 04, 2010 8:40 pm
I have two input files, "File 1" and "File 2" that have the same record length and format. I want to use Syncsort to to remove the records that exist on File 1 from File 2 and write all records from File 1 and only the unmatched records from File 2 in one output file. The matched records from File 2 can be discarded.
Questions:
What tool should I use?
Can this be done in one sort step?
If so, can you provide a generic example?
If not, I can easily accomplish this with two steps.
The key is the first 33 bytes of the 500-byte LRECL. Sample data:
Questions:
What tool should I use?
Can this be done in one sort step?
If so, can you provide a generic example?
If not, I can easily accomplish this with two steps.
The key is the first 33 bytes of the 500-byte LRECL. Sample data:
IN 00101ABC00000000000123456789
IN 00101DEF00000000000234567890
IN 00101DEF00000000000234567890