Float to Varchar Data Type conversion

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
synsog
Premium Member
Premium Member
Posts: 232
Joined: Sun Aug 01, 2010 11:01 pm
Location: Pune

Float to Varchar Data Type conversion

Post by synsog »

I am converting float(126) to varchar(255) using transformer function DFloatToStringNoExp(<inputcolumn>,10) .Source is oracle and target is sequential file.
Source column data is 80721804.076 but in target i am getting the value 80721808.

I don't want to use cast at oracle side.Can any one help me to get the proper result ?
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”