[IBM][CLI Driver] CLI0182W Fractional truncation. SQLSTATE

satyasur · Post by **satyasur** » Mon Jul 05, 2010 3:17 am

Hello all,

I am facing the following issue with one of my jobs:
[IBM][CLI Driver] CLI0182W Fractional truncation. SQLSTATE

In the job there ia a column which is generated by multiplication of an integer coulmn(int 10) and a decimal (decimal 13)column in the source sql. The result is stored in an integer (int 10) column via a transformer.
( i have checked the database for the lengths and they match the lengths taken in the etl job)

integer*decimal -----> integer

i suspect this is causing the error.

what is the best way to handle this situation?

any pointers?

ArndW · Post by **ArndW** » Mon Jul 05, 2010 3:44 am

If your target column is an integer then, as you suspected, the real number passed to it gets truncated. If you cannot make the target field contain decimals then I would explicitly perform the real -> integer conversion in DataStage and avoid the error. You can either round or truncate.

satyasur · Post by **satyasur** » Mon Jul 05, 2010 3:52 am

ArndW wrote:If you target column is an integer then, as you suspected, the real number passed to it gets truncated. If you cannot make the target field contain decimals then I would explicitly perform the real -& ...

hmmmm not being a premium member hurts :(

lost the crux. :cry:

ArndW · Post by **ArndW** » Mon Jul 05, 2010 4:02 am

The important part is visible. Perform an explicit truncation or rounding if you wish to get rid of the warning, or write to a column that supports decimals.

satyasur · Post by **satyasur** » Mon Jul 05, 2010 4:53 am

ArndW wrote:The important part is visible. Perform an explicit truncation or rounding if you wish to get rid of the warning, or write to a column that supports decimals.

Thank you for the pointer :)
will try it.