Page 1 of 1

Column Export warnings

Posted: Wed Jun 13, 2007 7:51 pm
by mchaves
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?

Posted: Wed Jun 13, 2007 9:37 pm
by ray.wurlod
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.

Posted: Wed Jun 13, 2007 10:55 pm
by JoshGeorge
Don't specify output column length (leave it empty) or specify output type as unknown.

Posted: Thu Jun 14, 2007 12:36 am
by mchaves
Thanks Guys.

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

Well done!!!

Cheers
MC