Implicit Conversion on summing numeric columns

[Marley777]

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.

[ray.wurlod]

There isn't. You can demote them to warnings or suppress them using a message handler, but you can not prevent them.

[Marley777]

ok - thanks for the reply.