Implicit rounding difference between 8.7 and 11.5

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
Posts: 5
Joined: Thu May 18, 2017 1:41 am

Implicit rounding difference between 8.7 and 11.5

Post by DamienF »

Hello guys,

I'm having an issue with a classic paralell job doing some calculation and then writing into an Oracle Database.

At the end the calculation goes for 77.275.

When writing it into a text file, no issue. But when going into an Oracle Table into a NUMBER(10,2) the result goes for 77.28 with Datastage 8.7 and for 77.27 with Datastage 11.5.

I would like the result to be the same as 8.7 when tie occurs i want it to be rounded to the upper bound.

The APT_DECIMAL_INTERM_ROUND_MODE variable does exists but I couldn't find a value matching my needs.

Any idea ?

Is it a known behavior ?

Premium Member
Premium Member
Posts: 2895
Joined: Wed Aug 03, 2011 6:16 am

Post by qt_ky »

Choose a job you love, and you will never have to work a day in your life. - Confucius
Post Reply