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)
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.
Last edited by ArndW on Mon Jul 05, 2010 4:01 am, edited 1 time in total.
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 -& ...
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.
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.