MVSFORUMS.com

[somuk]

Hi
Can I use SYNCSORT for the following requirement?

[kolusu]

Somuk,

Try this Job. A brief explanation of the job. since the amount is numeric edited we need to convert it into zoned decimal to perform the sum.

So using INREC FIELDS we copy the 80 bytes as is and we put the amount field in 81st byte removing the comma and decimal point.

Using OUTREC FIELDS we convert the amount at 81st byte which is of floating sign format to zoned decimal for a length of 6.

Now using SECTIONS on OUTFIL we achieve the desired results.

[somuk]

Thank you very much Kolusu.
If my input dateset is FBA and the output needs to be FB ,do I need to change anything in this job?
_________________
Regds,
Somu

[kolusu]

somuk,

Just Code RECFM=FB on the SORTOUT dataset.

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu