Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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: 1072
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: 10375
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 Moving a COMP-3 Variable to a Numeric... ajayachander COBOL Programming 2 Thu Dec 14, 2017 5:46 pm
No new posts Merging 2 records at multiple rows wi... Bijesh DFSORT/ICETOOL 2 Wed Dec 06, 2017 1:50 am
No new posts Extract record for change in combinat... Trinadh DFSORT/ICETOOL 6 Thu Nov 23, 2017 3:32 pm
No new posts Compare VSAM files using DFSORT pshongal DFSORT/ICETOOL 5 Thu Nov 23, 2017 10:24 am
No new posts Fetching data from JHS as per the cur... arunsoods All Other Mainframe Topics 4 Wed Nov 22, 2017 1:54 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us