Unable to set output decimal field value

xch2005 · Post by **xch2005** » Thu May 05, 2011 9:06 am

Hi,

The job what I am trying to do is get all the records from Sybase table and load Oracle table (Upsert mode). During the job execution the following warning message is thrown.

Unable to set output decimal field value from argument string '9.9999999999999995e-08' in function setOutputFieldAsDecimal() for field '10' in output dataset '0'.

field 10 is basically a char(9) and target also is char(9). It is just a column to column mapping and nothing more is done in that column.

Appericiate if I can get some suggestions on this.

Thanks,
SP

jwiles · Post by **jwiles** » Thu May 05, 2011 9:52 am

What is the corresponding datatype within Sybase (the source)? You need to either match the datatypes when you extract the data or get Sybase to convert the data to a standard numeric format instead of scientific notation when placing into a string. Your Sybase DBAs can help with the proper SQL for the latter.

Regards,

xch2005 · Post by **xch2005** » Thu May 05, 2011 11:47 am

I see the datatype as char(9) only in Sybase

ray.wurlod · Post by **ray.wurlod** » Thu May 05, 2011 3:38 pm

Maybe you're looking in the wrong field. They are numbered from zero.

xch2005 · Post by **xch2005** » Fri May 06, 2011 11:16 am

Yes, you are right. The next column was a float column and that had actually caused the issue.

xch2005 · Post by **xch2005** » Fri May 06, 2011 11:18 am

There was invalid data in the column and now looks fine