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.
sum of column decimal(26,3)
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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?
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.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.