View previous topic :: View next topic |
Author |
Message |
nex Beginner
Joined: 22 May 2003 Posts: 8 Topics: 4
|
Posted: Thu Sep 15, 2005 4:34 pm Post subject: Matching records with Sort |
|
|
I have this requirement. I need to match records of 2 files FILE1 (LRECL 80) and FILE2(LRECL 130).
FILE1: ( Data in col. pos 3 - 12) (KEY = Col. 3-12)
Code: | aa aaa aaa
bb bbb bbb
cc ccc ccc |
FILE2: ( Data in col. pos 1 - 10 , 11-20) (KEY = Col. 1-10)
Code: | aa aaa aaa fsdf dsaj
bb bbb bbb fsfs
cc ccc ccc fsfs
dd ddd ddd fsfs
ee eee eee f ff |
In output I want records from FILE2 matching key in file1:
Code: | aa aaa aaa fsdf dsaj
bb bbb bbb fsfs
cc ccc ccc fsfs |
For every key in FILE1 , there will be a corresponding record in FILE2.
Has to be done in SORT. My shop doesn't have EasyTrieve. |
|
Back to top |
|
![](templates/subSilver/images/spacer.gif) |
kolusu Site Admin
![Site Admin Site Admin](images/ranks/adminpic.jpg)
Joined: 26 Nov 2002 Posts: 12369 Topics: 75 Location: San Jose
|
|
Back to top |
|
![](templates/subSilver/images/spacer.gif) |
|
|