Implicit conversion from source type "int32" to re

santhooosh.c · Post by **santhooosh.c** » Wed Jun 18, 2008 3:01 am

Hi Buddies,

help me to get out the warning

Implicit conversion from source type "int32" to result type "string[max=6]": Converting number to string.

trying to convert int (2) to varchar(6), in modify stage, not able to find suitable function name

ArndW · Post by **ArndW** » Wed Jun 18, 2008 3:41 am

There are two options. You can use DS message handling to demote this warning to informational or even suppress it, or you can use a DecimalToString() conversion (I will assume that you are asking about a transform stage conversion as opposed to a modify stage one).

ray.wurlod · Post by **ray.wurlod** » Wed Jun 18, 2008 4:50 pm

There is no such thing as int(2). You have an int32 with a display width of 2. The largest possible int32 has 11 characters. This will not fit in a string[6] and therefore DataStage generates this alert. You may have knowledge about your data that might allow you to use int16, where six characters in the string would be sufficient.