Column Export warnings

mchaves · Post by **mchaves** » Wed Jun 13, 2007 7:51 pm

Hi All,

I am trying to eliminate some warnings generated by the column export stage.

This is the message "When binding output interface field "PK" to field "PK": Implicit conversion from source type "string" to result type "string[max=50]": Possible truncation of variable length string.

It seems the column export generates a concatenated string without length explicit defined and when it outputs the result to the output column which has a length specified this causes a warning.

Have checked this issue in other posts but I don't want to suppress this message by message handler.

Any ideas?

ray.wurlod · Post by **ray.wurlod** » Wed Jun 13, 2007 9:37 pm

Umm.. define an explicit length in the export metadata? Maybe that's what you are doing, and the unbounded string is purely internal. In that case (unless you can associate the stage with a schema file) there's not much I can suggest.

JoshGeorge · Post by **JoshGeorge** » Wed Jun 13, 2007 10:55 pm

Don't specify output column length (leave it empty) or specify output type as unknown.

mchaves · Post by **mchaves** » Thu Jun 14, 2007 12:36 am

Thanks Guys.

Josh, your recommendation worked very well.. all warnings disappered.

Well done!!!

Cheers
MC