Page 1 of 1

Binding error

Posted: Thu Nov 17, 2005 10:40 am
by medakiran
hi all,
My job's being aborted as i'm getting the following error

"DSIN: Error when checking operator: When binding output schema variable "outRec": When binding output interface field "SSN" to field "SSN": Implicit conversion; from source type "decimal[9,0]" to result type "string[max=9]": Not enough room in string for decimal[9,0]
Error when checking operator: When binding output schema variable "outRec": When binding output interface field "ST_NMRC_CD" to field "ST_NMRC_CD": Implicit conversion; from source type "decimal[2,0]" to result type "string[max=3]": Not enough room in string for decimal[2,0]"


DSIN is my input and it is a dataset stage and the fields with errors are basicall pulled from DB2 stage and then being converted to VarChar(9) in a Transformer stage then sent to the Dataset stage( this is done in a separate job). Then the Dataset stage is the new source with the fields as Varchar, but for some reason the job is being aborted.

Also, the same job is running fine on our Different Server. I'm tryin to run this on a diff. Server.
Any thoughts on this please

Thanks,
kir.

Posted: Thu Nov 17, 2005 12:40 pm
by ArndW
Could you make your VarChar() columns larger to accomodate the actual data length with a potential decimal place - and see if it works and what the data values are?