I am doing a group by/sum select in a DB2/UDB stage. The amounts being summed are defined on the table as DECIMAL(15,2). The problem is that when I try and pass these values to the rest of the jobstream I get the following warning:
Implicit conversion from source type "decimal[31,2]" to result type "decimal[15,2]": Possible range limitation. [api/interface_rep.C:6240]
Almost looks like datastage doubles the definition when using a sum.
When the sum is taken off of the numeric fields the warning disappears. Any ideas on how to get rid of the warning message when storing these amounts as (15,2) is the requirement?
Thanks.
Implicit Conversion on summing numeric columns
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: