IBM Mainframe Forum

Hi,
So, I have been playing around the Header and Trailer options in OUTFIL. From what I could gather from the manuals is, if I have to take a total amount (or sum) of my data like below with a comma



Then I would say in OUTFIL



which should give me the result I require.

If I have a decimal point in my data like below



Then I could say in OUTFIL as



which should give me what I want

But, what if my data looks like below with a mixture of both commas and decimal points



Could you guys let me know if my required result is 1,110.15 then how can I achieve this. Do I have to reformat my data to remove the comma or decimal point ? or is there any way I would get a summation of the number with mixture of these symbols.

JCL is the control statements you use to direct the system to assign the resources required to run the programs required to perform the tasks you require.

JCL cannot manipulate your data in any way.

Based on your use of OUTFIL, I suspect this topic belongs in the DFSORT/ICETOOL/ICEGENER forum or the Syncsort/Synctool forum.

I will transfer this topic to the DFSORT forum for you. If you use Syncsort, you can transfer this topic to the Syncsort/Synctool forum yourself.

If you have a decimal point in addition to the commas, M18 instead of M12 should give you what you want.

These users thanked the author Robert Sample for the post:

Aech (Mon Jul 16, 2018 9:04 pm)

Thanks Robert, M18 worked as expected and I can see the desired results.

Much appreciated.

Glad to hear it worked.