MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Data issues for removing records frm file based on condition

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Job Control Language(JCL)
View previous topic :: View next topic  
Author Message
pai_sunil_bs
Beginner


Joined: 19 Sep 2005
Posts: 21
Topics: 11

PostPosted: Fri Aug 08, 2008 4:57 am    Post subject: Data issues for removing records frm file based on condition Reply with quote

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.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Job Control Language(JCL) All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group