Lost precision float to char

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
jusami25
Premium Member
Premium Member
Posts: 84
Joined: Tue Oct 26, 2004 12:49 am

Lost precision float to char

Post by jusami25 »

Hi experts,

i have a float(16) field with the number like 59330897.3028773 but when i pass to a char(60) i loosing precision and i got 59330897.3029. What can i do?

Thanks in advance.
Top
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

Try sending to varchar(). Set the scale appropriately.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Top
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

It would be nice to share the solution with us :roll:
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Top
Post Reply

Return to “IBM<sup>®</sup> Infosphere DataStage Server Edition”