Alissa Margulies
SYNCSORT Support
Joined: 25 Jul 2007
Posts: 496
Location: USA
|
|
|
|
| Shivendu wrote: |
| Need to compare data in two files FILE1 and FILE2. Data which is present ONLY in FILE2 should be written to a new file FILE3 (i.e removing duplicates) |
Coding a simple SyncSort JOIN application will also produce the desired results. For example:
| Code: |
//STEP1 EXEC PGM=SORT
//SYSOUT DD SYSOUT=*
//SORTJNF1 DD DSN=FILE1,...
//SORTJNF2 DD DSN=FILE2,...
//SORTOUT DD DSN=FILE3,...
//SYSIN DD *
JOINKEYS FILES=F1,FIELDS=(1,3,A)
JOINKEYS FILES=F2,FIELDS=(1,3,A)
JOIN UNPAIRED,F2,ONLY
SORT FIELDS=(1,13,CH,A)
DUPKEYS FIELDS=NONE
/* |
|
|
