trying to get a Varchar column and assign to decimal column

prasanna2100 · Post by **prasanna2100** » Thu Apr 24, 2008 3:54 pm

hi all,
While iam trying to get a Varchar data and trying to assign in to a Decimal type column.
getting an error

Unable to set output decimal field value from argument string '' in function setOutputFieldAsDecimal() for field '28' in output dataset '0'.

suggestions please

kumar_s · Post by **kumar_s** » Thu Apr 24, 2008 4:31 pm

Are you tryring in Transformer stage? What function, you are using in?
What is the input / Output Data length and what is assigned in Datastage?

ray.wurlod · Post by **ray.wurlod** » Thu Apr 24, 2008 4:34 pm

"" is not valid as a Decimal data type. You are supplying "" and asking for it to be treated as Decimal. This is neither permitted nor possible.

ramesh_inform · Post by **ramesh_inform** » Fri Apr 25, 2008 4:58 am

StringToDecimal(%string%,[%rtype%])

try this in transfromer
hope it works

ramesh_inform · Post by **ramesh_inform** » Fri Apr 25, 2008 5:28 am

StringToDecimal(%string%,[%rtype%])

try this in transfromer
hope it works

ramesh_inform · Post by **ramesh_inform** » Fri Apr 25, 2008 5:31 am

StringToDecimal(%string%,[%rtype%])

try this in transfromer
hope it works