DSXchange

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

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,

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

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

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

There was invalid data in the column and now looks fine