Job Warning

phanikumar · Post by **phanikumar** » Thu Dec 08, 2011 1:10 am

Hi There,

I am running a parallel job where it's giving me a warning message like

Implicit conversion from source type " "string" to result type "string[257]": Possible truncation of variable length string.

I am not doing any unicode conversion it's just string to string.Any ideas how to suppress this warning.

Regards

Kumar

chandra.shekhar@tcs.com · Thu Dec 08, 2011 3:39 am

Are you using any conversion function in your job??
ANd for second part, you can either suppress or demote your warnings to info in the director using message handler.
Just right click on the warning and you'll see the option

premupdate · Post by **premupdate** » Thu Dec 08, 2011 3:46 am

Probably "string" alone represents a char or varchar field which is unbounded in its length.So the warning.

chulett · Post by **chulett** » Thu Dec 08, 2011 7:34 am

An implicit conversion is one where the engine itself (rather than 'you' in the job) are performing the conversion. This as opposed to an explicit one. As noted, you are moving data from an unbound string to a bound one and thus it is warning you that it just might possibly truncate the data.

You could use substring to suppress the warning.