sum of column decimal(26,3)
Posted: Fri Nov 02, 2007 2:13 am
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.
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.