Decimal round off issue

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
bond88
Participant
Posts: 109
Joined: Mon Oct 15, 2012 10:05 am
Location: USA

Decimal round off issue

Post by bond88 »

Hi,
I am facing an issue with decimal round off. I used an aggregator stage to calculate the sum of a decimal field. I tried changing it to float and again in transformer used Dfloat to Decimal function still it is rounding off decimal places. Can someone please guide me how can I restore decimals without getting round off?

Thank you,
Bhanu
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

Investigate the environment variable APT_DECIMAL_INTERIM_SCALE, the "type" argument of the DFloatToDecimal() function, and the Ceil() and Floor() functions.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
Post Reply

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