sum of column decimal(26,3)

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
dashpriya
Participant
Posts: 28
Joined: Thu Mar 09, 2006 12:57 am
Location: mumbai
Contact:

sum of column decimal(26,3)

Post by dashpriya »

I am calculating sum of column Col1 having datatype decimal(26,3) in db2 stage and After calulating SUM the datatype for output column is Double (31,3). Later I want to populate this double(31,3) value in Output column Col1 having data type Decimal(26,3).I want to populate data in db2 table.

I did this double(31,3) to Decimal(26,3) in transformer with function Dfloat to decimal(). but it is throwing following warning

APT_CombinedOperatorController(1),1: APT_Decimal::operator=: the source decimal has even precision, but non-zero in the leading nybble, or is too large for the destination decimal.

please suggest the possible solutions thanks In Advance.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

The Double has 31 significant digits.
Decimal has 26.
The message tells you that you can't shoehorn the one into the other.
Can you investigate reducing the size of the Double?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply