View previous topic :: View next topic
|
Author |
Message |
kalyanonnet
New User
Joined: 24 Oct 2006 Posts: 3
|
|
|
|
Hi,
I have a requirement. I have sequential two files.
Master file
000001 1001 KALYAN 20000
000002 1002 BBBB 5000
000003 1003 CCCC 6000
000004 1004 NNNN 7000
000005 1006 FFFFF 9000
000006 1007 TTTT 8000
Transaction File
1001 kalyan 20000
1001 kalyan 30000
1001 kalyan 20000
1002 bbbbbb 4000
1002 bbbbbb 20000
1002 bbbbbb 20000
1004 nnnnnn 20000
1004 nnnnnn 3000
1004 nnnnnn 1000
1004 nnnnnn 30000
1006 ffffff 6000
1006 ffffff 60000
Now i want to read first record from Master file (i.e. 000001) and verify with trans and retrieve all the matching records(i.e. 000001). Then the second record from Master file (i.e. 000002) and verify it with trans file (000002) and get related records and so on ..........
Note: When i try to fetch third match(000003) in trans file, I should not read the previous records(i.e. 000001,000002) in Trans file.
Can anyone explain me ? |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
Back to top |
|
|
mmwife
Super Moderator
Joined: 30 May 2003 Posts: 1592
|
|
|
|
Hi Dick,
Thanx for the "attaboy". Unfortunately, it's only 1/2 the ans.
The other 1/2 uses the control break algorithm. It's unusual to see them
both in the same pgm.
On 2nd thought, the control break logic for this one is trivial. Unless he has to report transaction activity. |
|
Back to top |
|
|
|