multiply two fields of a record using sort

kumarmca1 · New User Joined: 06 Jul 2009 Posts: 13 Location: chennai

Hi,

I want to multiply two records from the a record of the input file and write the product in the output file.

Ex:

000023050007789022222

My requirement is to multiply fields 023 and 05 to produce 115 and replace 023 and write it in the output.

Regards,
Nirmal

Frank Yaeger · Posted: Wed Jan 19, 2011 12:26 am Post subject:

You can use a DFSORT job like the following to do what you asked for:

gcicchet · Posted: Wed Jan 19, 2011 3:06 am Post subject:

Hi Frank,

should the overlay be

Frank Yaeger · Posted: Wed Jan 19, 2011 3:12 am Post subject:

Yes, you're right that 4-6 should be overlayed. I've fixed my post.