Exclude data from multiple input files without merging

ramkumar.thulasingam · New User Joined: 22 Nov 2011 Posts: 2 Location: AUSTRALIA

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.

gcicchet · Posted: Mon Dec 05, 2011 4:03 am

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

ramkumar.thulasingam · New User Joined: 22 Nov 2011 Posts: 2 Location: AUSTRALIA

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.

gcicchet · Posted: Mon Dec 05, 2011 6:50 am

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

prino · Posted: Mon Dec 05, 2011 6:58 am

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.

enrico-sorichetti · Posted: Mon Dec 05, 2011 8:55 am

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.