convert INT to TINY INT in datastage?

pkll · Post by **pkll** » Tue Aug 26, 2014 8:57 am

Hi All,

My source column datatype is INT 2 and
My output column datatype is TINY INT 3
when I execute job I am getting below warning message.

Implicit conversion from source type int8 to result type uint8 possible range limitation

Please advice me how to convert INT to TINY INT in datastage?

Thanks In Advance..

chulett · Post by **chulett** » Tue Aug 26, 2014 9:48 am

You already are. That's just a warning alerting you to the fact that your data may not fit. If you somehow know that it always will, demote it. Otherwise you'll need some sort of a legitimate conversion algorithm to manipulate 4 bytes to fit into 1.

Mike · Post by **Mike** » Tue Aug 26, 2014 9:56 am

You've already done it.

Fyi, the warning message that you quoted has nothing to do with your source integer which would be an int32.

The warning message is telling you that there was an implicit conversion of a signed tinyint (int8) to an unsigned tinyint (uint8)... the obvious range limitation being that the target can not hold negative values.

You can avoid the warning message by doing an explicit conversion.

Mike