raja1128
New User
Joined: 09 Jan 2007 Posts: 17 Location: india
|
|
|
|
Hi all,
I need your help.
I have to compare two files using SYNCSORT as mentioned below…
Input files and output files have same attributes: recl=41 , PS, FB, no duplicates, sorted.
Key is first two fields. And fields are…
05 AAA PIC S9(11) COMP-3.
05 BBB PIC X(03).
05 CCC PIC S9(11) COMP-3.
05 DDD PIC S9(11) COMP-3.
05 EEE PIC S9(11) COMP-3.
05 FFF PIC X(8).
05 GGG PIC X(6).
Example -
INPUT:
File1:
AA11111
BB22222
CC33333
File2:
BB22222
CC66666
DD44444
OUTPUT:
File1: records from file1 where key found in file1 but not in file2
AA11111
File2: records from file2 where key found in file2 but not in file1
DD44444
File3: records from file1 where key found in both files but non-key fields doesn’t match.
CC33333
File4: records from file2 where key found in both files but non-key fields doesn’t match.
CC66666
we have SYNCSORT FOR Z/OS 1.3.2.0R
hope I have given all details.
Thank you. |
|