Multiplication errors in PX?

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
seanc217
Premium Member
Premium Member
Posts: 188
Joined: Thu Sep 15, 2005 9:22 am

Multiplication errors in PX?

Post by seanc217 »

This one is strange...

I am trying to do a calcualtion in a PX transformer.
In the transformer I am applying the formula...

(x/y) * z

where x is a decimal 13,2
y is an integer and z is an integer

The result variable is defined as 13,2

The numbers are

x = 00000167037.66
y = 181
z = 181

The result should be: 167037.66 (z can change depending on other factors in this case it is the same)

The result I get is: 00000707037.66

Any ideas?

TIA
seanc217
Premium Member
Premium Member
Posts: 188
Joined: Thu Sep 15, 2005 9:22 am

Post by seanc217 »

I traced this down to a patch IBM support provided me to fix an issue with tranformers with a large amount of columns. Once I restored to a pre-patch state, no problems.

FYI
Post Reply