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?
[IBM][CLI Driver] CLI0182W Fractional truncation. SQLSTATE
Moderators: chulett, rschirm, roy
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.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
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.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>