Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Exclude data from multiple input files without merging

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
ramkumar.thulasingam

New User


Joined: 22 Nov 2011
Posts: 2
Location: AUSTRALIA

PostPosted: Mon Dec 05, 2011 3:40 am    Post subject: Exclude data from multiple input files without merging
Reply with quote

Hi All,

I have a requirement that I have to exclude some records from multiple input files for example DVLP.SAMPLE.FILE1, DVLP.SAMPLE.FILE2, DVLP.SAMPLE.FILE3 ........ say there are 50 files like this.

I have to exclude records based on few conditions.

Point here is all the input files should not be merged. They have to be maintained individually. After excluding the records, excluded records to be written to a separate file.

Could someone help me out on this using sort.
Back to top
View user's profile Send private message

gcicchet

Senior Member


Joined: 28 Jul 2006
Posts: 1703
Location: Australia

PostPosted: Mon Dec 05, 2011 4:03 am    Post subject:
Reply with quote

Hi,

please explain what you mean by input files should not be merged and do you want excluded records in 1 output file or 1 output file for each input file ?


Gerry
Back to top
View user's profile Send private message
ramkumar.thulasingam

New User


Joined: 22 Nov 2011
Posts: 2
Location: AUSTRALIA

PostPosted: Mon Dec 05, 2011 6:30 am    Post subject:
Reply with quote

I want to exclude one or two records from each input file.

Each file will be having Header , detail and Trailer.

When we remove one or two records from detail, we have to update the count of details in Trailer accordingly on each file.

Hope this explains you . Please let me know if still this is unclear.
Back to top
View user's profile Send private message
gcicchet

Senior Member


Joined: 28 Jul 2006
Posts: 1703
Location: Australia

PostPosted: Mon Dec 05, 2011 6:50 am    Post subject:
Reply with quote

Hi,

1. you must learn to answer questions when asked.

2. you must learn to ask questions and not change your mind from one post to another.

Your latest request does not resemble anything like your original request.

3. I would start from scratch and state exactly what you want.

what sort product are you using ?

provide some sample data, how do you determine what is the header or data or trailer, format of the trailer, RECFM LRECL.

Have you tried anything at all, if so, what problems are you having ?


Gerry
Back to top
View user's profile Send private message
prino

Senior Member


Joined: 07 Feb 2009
Posts: 1027
Location: Oostende, Belgium

PostPosted: Mon Dec 05, 2011 6:58 am    Post subject:
Reply with quote

Quantas, your employer according to your profile, has never lost a plane, but with the likes of you working there they will quite likely do so very soon.

Your requirement cannot be solved with JCL, nor with sort, so stop wasting our time. Go away and start writing your own programs and don't rely on others to do your job for you.
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10274
Location: italy

PostPosted: Mon Dec 05, 2011 8:55 am    Post subject: Reply to: Exclude data from multiple input files without mer
Reply with quote

the initial question does not make any sense really.
the process of deleting records and updating counts is completely unrelated to the number of files to be processed.

after having developed the solution, applying it to 1,2,3, .... 357246 datasets is a moot point.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts copying data without knowing location arunsoods DFSORT/ICETOOL 6 Thu Jul 20, 2017 1:03 pm
This topic is locked: you cannot edit posts or make replies. Fetching data from BAI File arunsoods JCL & VSAM 1 Wed Jul 19, 2017 4:28 pm
No new posts Changeman get multiple "Browse C... elixir1986 Compuware & Other Tools 4 Fri Jul 14, 2017 1:48 am
No new posts Loading data to table gives wrong for... Raghu navaikulam DB2 16 Thu Jul 13, 2017 2:11 pm
No new posts How to write Specific Fields from Mul... Padhu SYNCSORT 6 Thu Jul 06, 2017 10:26 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us