Page 1 of 1

Parallel job implicit conversion error

Posted: Thu Mar 10, 2011 4:45 pm
by wfkurtz1
Here is the error I am receiving from a Column Generator stage in a parallel job. Oracle 10g used for both source and target stages.

SAME_DAY: When checking operator: When binding output interface field "AMOUNT" to field "AMOUNT": Implicit conversion from source type "decimal[38,10]" to result type "decimal[17,2]": Possible range/precision limitation.

Thanks in advance for your help

Posted: Thu Mar 10, 2011 6:00 pm
by chulett
What part do you need help with? Did you do an exact search for "Possible range/precision limitation" to understand the warning?

Posted: Fri Mar 11, 2011 8:15 pm
by wfkurtz1
Thanks we get rid of the warning by using a double datatype for the Datastage column (SAME_DAY) concerned.

Thanks.