I am trying to refresh data from a sybase db to DB2 but failing due to some awkward error. I have around 60 tables and data refresh is failing for 2 tables. The error is as follows:"Table dbo.redemptxxxx could not be refreshed. The precision 10 is too small for the decimal value 20727.443600"
The error is on an amount column. All the tables have user defined data types in source db and it refers to a DECIMAL datatype of 18,6. Ideally it should work well for the value above. I had tried out changing the data type to DOUBLE but that too could not resolve the issue. Please advice if anyone has faced similar issue.