Syncsort – convert FL to displayable format



Support for NetApp SyncSort for z/OS, Visual SyncSort, SYNCINIT, SYNCLIST and SYNCTOOL

Syncsort – convert FL to displayable format

Postby mishagtk » Fri Mar 18, 2016 7:54 pm

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
mishagtk
 
Posts: 2
Joined: Fri Mar 18, 2016 7:18 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Syncsort – convert FL to displayable format

 

Re: Syncsort – convert FL to displayable format

Postby BillyBoyo » Fri Mar 18, 2016 9:23 pm

What have you tried, and with what results? Look at FL and and perhaps FD data-types. I don't have access to SyncSORT.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 264 times

Re: Syncsort – convert FL to displayable format

Postby mishagtk » Fri Mar 18, 2016 11:03 pm

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
mishagtk
 
Posts: 2
Joined: Fri Mar 18, 2016 7:18 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Syncsort – convert FL to displayable format

Postby NicC » Sat Mar 19, 2016 5:27 am

Why have you posted this in the JCL part of the forum and not the Syncsort part of the forum?
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 2680
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisys (almost)
Has thanked: 4 times
Been thanked: 102 times


Return to Syncsort/Synctool

 


  • Related topics
    Replies
    Views
    Last post