IBM Mainframe Forum

Hi,

I have 30 PS files with each file having huge number of records. I need to pull certain records to output file from these 30 input files based on a given criteria. I am able to do it successfully but finding it very difficult to know from which input file these records have come. I tried manual find by opening each file but it is proving very time consuming due to the file size.

Would you please suggest any method using SORT or other utility that gives me a quick solution to this problem

Please help.

Thanks.

Hello,

If you use a separate copy execution for each file, you could append a "file-id" at the beginning or end of each record to identify the file from which the data was pulled.

As Dick had mentioned, if there is no identifying field within the record, then you can pre-process the data sets to add one.
For example, you can use OUTREC to add a corresponding number (01-30) at the end of each record.

For each input data set, change the OVERLAY value (C'02', C'03', ...C'29', C'30').

Thank you. So, I will have 30 such steps to apply an identifier on each file. Is not it?

Thanks.

Yes, that is correct. Unless you can somehow modify the application that created the file originally to include such an identifier...