ramsri
Active User
Joined: 18 Oct 2008 Posts: 380 Location: India
|
|
|
|
Hi,
I have two files (RECFM=FB, LRECL=80)
File-1:-
Code: |
----+----1
abc0071
xyz0123
coj1688
sta1110
|
File-2:
Code: |
----+----1
abc0070
coj1687
brv0009
sta1107
|
My requirement is to match both files on key starts at 1st byte (length = 3) in each file and calculate difference (number starts at 4th byte and length = 4) between matched records and write -
Output-1 - difference between matched records should be 1
Output-2 - difference between matched records should be more than 1
Expected Output-1:
Code: |
----+----1----+----2
abc0071abc0070
coj1688coj1687
|
Expected Output-2:
Code: |
----+----1----+----2
sta1110sta1107
|
I am succeeded upto JOINKEYS but don't know how to get it to output. Please help.
Thanks. |
|