rounding occurs when I mulitply fields together

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
Bill_G
Premium Member
Premium Member
Posts: 74
Joined: Thu Oct 20, 2005 9:34 am

rounding occurs when I mulitply fields together

Post by Bill_G »

I am attempting to multiply 3 fields together in a transformer, however the output is rounded. for instance .45 shows as 0. all three fields are designated at Decimal (38,2) and my output field is also Decimal 38,2. The output is the same regardless if i write to a sequential file or to my oracle 9i table.

Thanks

Bill
Top
Post Reply

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