GauravKudesiya Warnings : 1 New User
Joined: 11 Oct 2008 Posts: 74 Location: Chicago, IL
|
|
|
|
Hello Everyone,
I have two input files F1 and F2, each having LRECL=80 and RECFM=FB
Now I need to compare them and if records matches on keys from both files then its fine.
but if the record is present only in one file, then we need to write those records in another file.
If record is only present in F1 then we need to write that on F3 and if the record is only present in F2 then we need to write that record on F4.
I am looking for possible options to implement this, Using Syncsort/Filemanager etc.
Input files
File 1
Code: |
AAAAAAAAA
BBBBBBBBB
CCCCCCCCC
DDDDDDDDD
EEEEEEEEE
FFFFFFFFF
GGGGGGGGG |
File 2
Code: |
AAAAAAAAA
CCCCCCCCC
DDDDDDDDD
FFFFFFFFF
HHHHHHHHH
IIIIIIIII
JJJJJJJJJ
KKKKKKKKK |
Required Output
File 3 : Records only in File 1
Code: |
BBBBBBBBB
EEEEEEEEE
FFFFFFFFF
GGGGGGGGG |
File 4 Records only in File 2
Code: |
HHHHHHHHH
IIIIIIIII
JJJJJJJJJ
KKKKKKKKK |
Thanks for any help!! |
|