Page 1 of 1

Syncsort – convert FL to displayable format

PostPosted: Fri Mar 18, 2016 7:54 pm
by mishagtk
My question regarding Syncsort. How to convert COMP-2 (double precision floating point) field to the readable format
Example: COMP-2 stored value as +3.056716 E+04. I need to display this value as 30,567.16

Thank you,
Mike

Re: Syncsort – convert FL to displayable format

PostPosted: Fri Mar 18, 2016 9:23 pm
by BillyBoyo
What have you tried, and with what results? Look at FL and and perhaps FD data-types. I don't have access to SyncSORT.

Re: Syncsort – convert FL to displayable format

PostPosted: Fri Mar 18, 2016 11:03 pm
by mishagtk
Thank you for replying me back.

I’m using following sort statement to reformat field:

SORT FIELDS=COPY
OUTREC FIELDS=(23,18, 207,8,FL,EDIT=(STTTTTTTTTTTTTT.TT),SIGNS=(+,-))

My input in floating point format: +3.056716 E+04
On the result I’m losing decimal points: +00000000030567.00
I’m expecting to get following: +00000000030567.16

Mike

Re: Syncsort – convert FL to displayable format

PostPosted: Sat Mar 19, 2016 5:27 am
by NicC
Why have you posted this in the JCL part of the forum and not the Syncsort part of the forum?