Conversion error calling conversion routine decimal_from_str
Posted: Wed Oct 14, 2015 4:09 pm
I've read the other threads already on datastage so I know this is a popular error, but I'd thought I'd just post again in case there were any fresh ideas how to get rid of the warning:
Input source is a varchar(11)
Destination is a decimal(11,0)
I've tried several other datatypes and combinations. I've trimmed, I've substringed, I've null handled, I've done everything that I can think of and yet I can't get rid of this warning.
The data is flowing right, I can i live with the warning being in the logs, but I don't wan't to have this known warning count against me in my stats of jobs running ok.
Code: Select all
Conversion error calling conversion routine decimal_from_string data may have been lost
Destination is a decimal(11,0)
I've tried several other datatypes and combinations. I've trimmed, I've substringed, I've null handled, I've done everything that I can think of and yet I can't get rid of this warning.
The data is flowing right, I can i live with the warning being in the logs, but I don't wan't to have this known warning count against me in my stats of jobs running ok.