warnig message in parallel extender job

studyguy2001 · Post by **studyguy2001** » Wed Mar 30, 2005 12:45 pm

hello.,

i am relatively new to DS. i am running th ejob with success but i am getting the following warning message.,

COLE_HEADER: When checking operator: When binding output interface field "In_Rec" to field "REC_DET": Implicit conversion; from source type "string" to result type "string[200]": Possible truncation of variable length string

please advice me as i am not able understand the above
thanks

ray.wurlod · Post by **ray.wurlod** » Wed Mar 30, 2005 2:46 pm

It's simply alerting you to the possibility that, because you have set a maximum string size on the output, but an arbitrary size on the input, any input string longer than 200 characters would be truncated.

studyguy2001 · Post by **studyguy2001** » Wed Mar 30, 2005 5:29 pm

ray.wurlod wrote:It's simply alerting you to the possibility that, because you have set a maximum string size on the output, but an arbitrary size on the input, any input string longer than 200 characters would be truncated.

so what are the changes you suggest in my job so that i can avoid all those warning messages.
thanks

T42 · Post by **T42** » Wed Mar 30, 2005 11:17 pm

Code: Select all

Left([input string], 200)

In Transformer.

Other solutions would be to ensure that your input data have that metadata defined (varchar(200)).

DSXchange

warnig message in parallel extender job

warnig message in parallel extender job

thanks ray