Re: Need assistance with SQL statement over QSYS2.SYSTABLESTAT

[Robert Clay <zreclay@xxxxxxxxx>]

Thanks, Tom.

That worked.

"Contrariwise, if it was so, it might be; and if it were so, it would 
be; but as it isn't, it ain't. That's logic."--Tweedledee

On 09/16/2013 12:38 PM, Tom E Stieger wrote:
> Robert-
>
> You are running into the rules DB2 uses for decimal precision with dividing.  The rules are in the info center for 7.1 here :  http://pic.dhe.ibm.com/infocenter/iseries/v7r1m0/index.jsp?topic=%2Fdb2%2Frbafzdecarithmetic.htm
>
> Basically, you need to cast you numerator and denominator to something like the following:
>
> DEC ( (DEC( Number_Rows, 32, 5)/ DEC(Number_Deleted_Rows, 32, 5) ) * 100.00 , 5, 2)
>
>
> -Tom Stieger
> IT Manager
> California Fine Wire