Page 1 of 1
Syncsort – convert FL to displayable format
Posted:
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
Posted:
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
Posted:
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
Posted:
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?