pai_sunil_bs Beginner
Joined: 19 Sep 2005 Posts: 21 Topics: 11
|
Posted: Fri Aug 08, 2008 4:57 am Post subject: Data issues for removing records frm file based on condition |
|
|
I tried searching the postings but did not get what I am looking for:
My scenario: There are 2 files DefaultersFile and MasterFile
Assume both files are FB and LRECL as 80
DefaultersFile
2
4
5
6
MasterFile
Header
1
2
3
4
7
Trailer
NondefaultersFile
Header
1
3
7
Trailer
I have a master File with accounts and I need to exclude all the accounts who are defaulters which I get from the DefaultersFile. I need to exclude such accounts from the MasterFile and create a NondefaultersFile.
I know how to exclude the defaulted accounts from the Masterfile using DefaultersFile as a Lookup.
However, due to some OLD data issues, The DefaultersFile does contain some accounts which are not present in the MasterFile (Ex:5,6) which is coming over to the NondefaultersFile. I do NOT want to bring it to the NondefaultersFile. How can this be done?
Also, by default, the ICETOOL is sorting the Header and Trailer records of the MasterFile and putting it over to the NondefaultersFile as if it is some record. I want to avoid this as well. How can this be done?
Please Help. |
|