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
Unable to set output decimal field value
Moderators: chulett, rschirm, roy
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,
Regards,
- james wiles
All generalizations are false, including this one - Mark Twain.
All generalizations are false, including this one - Mark Twain.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: