Warning while running the job

haivineetha · Post by **haivineetha** » Thu May 07, 2009 10:49 pm

I am getting the warning
"Unable to set output decimal field value from argument string '1078.72256' in function setOutputFieldAsDecimal() for field '6' in output dataset"

while runnig the job.The error is coming from a teradta source which is a befor dataset to a change capture stage.

PLease advide hw to resolve

ray.wurlod · Post by **ray.wurlod** » Thu May 07, 2009 11:41 pm

What are the data type, precision and scale setting for Field 6?

haivineetha · Post by **haivineetha** » Fri May 08, 2009 12:42 am

In datastage the column is an integer with precision 10

ray.wurlod · Post by **ray.wurlod** » Fri May 08, 2009 2:34 am

Try using a DecimalToDecimal() conversion.

haivineetha · Post by **haivineetha** » Fri May 08, 2009 3:26 am

It diidnt helped.. still warning is there..

haivineetha · Post by **haivineetha** » Fri May 08, 2009 7:09 am

Will this be an an environmental issue,since this job is running perfectly in prod.If yes,Please provide the solution

ray.wurlod · Post by **ray.wurlod** » Sun May 10, 2009 4:43 pm

Can't do that, as we don't have access to your environments. YOU do the comparison of environments, and let us know. Pay particular attention to the environment variables that affect the behaviour of decimal data types, though the difference may be elsewhere.