Binding error

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
medakiran
Participant
Posts: 19
Joined: Thu May 12, 2005 10:08 pm

Binding error

Post 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.
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post 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?
Post Reply