IBM Mainframe Forum

You didn't answer the question about whether there is other data on the files.

Oh I'm sorry about that !!!

There is no other data in all 3 input files.

startpos1 is the start of SHIPMENT, startpos2 is either of the /s in the date, startpos3 is the rightmost digit of Packed Units.

If you concatenate your three files and run that then it should isolate the three lines of interest.

Start with that, and confirm that it works.

Then provide the start position and lengths of the data you need.

Billy,

Thank you very much for your code.

But this will copy the whole line of the condition that matches and i will be getting 3 lines of output data right ?

but what i expected is " 13,398 48,483 10,343 35,635 671 1059 "

where

13,398 48,483 ==> is from input file 1
10,343 35,635 ==> is from input file 2
671 1059 ==> is from input file 3.


please guide & Help.

Then you can add something like the above. fill in/calculate the starts and lengths.

The idea is to put a sequence number on your three remaining records, just for ease of identification.

To get data from one record to another, you have to use WHEN=GROUP and PUSH.

You will end up with two records with partial data which you now want to discard, so we do that with OUTFIL INCLUDE for the one we want.

Once working you can do some tidying for more efficient use of the space, but for so few records, it is hardly worth it. Just comment it to say why it wasn't done

Not tested, but you wanted it ASAP. You'll have to work a bit, at least.

Yes. The first thing is to get the data you want to extract from isolated from the stuff you don't want. If that can't be done easily with an INCLUDE/OMIT, then something else is needed, so the results I requested need to be known.

Things don't just happen by magic.

Hi Guys,

Thank you very much for all your help. This has been finally completed.

good to hear it is working - thank you for letting us know.

If you post your solution, it might help someone later.

d