Re: Need assistance with SQL statement over QSYS2.SYSTABLESTAT

[Robert Clay <zreclay@xxxxxxxxx>]

Thanks for the input.  It's a work in progress and has been altered 
considerably since the initial post.

I've dropped the first CASE statement and another WHEN clause was added:

     WHEN Number_Rows = Number_Deleted_Rows THEN  50.00

So, the current Percent_Deleted (subject to change, of course) is:

, CASE
       WHEN ( Number_Rows = 0 ) AND ( Number_Deleted_Rows = 0 ) THEN   0
       WHEN ( Number_Rows > 0 ) AND ( Number_Deleted_Rows = 0 ) THEN   0
       WHEN ( Number_Rows = 0 ) AND ( Number_Deleted_Rows > 0 ) THEN 100.00
       WHEN   Number_Rows = Number_Deleted_Rows                 THEN  50.00
       WHEN ( Number_Rows > Number_Deleted_Rows )
         THEN  DEC( ( DEC( Number_Deleted_Rows , 32 , 5 )
                    / DEC( Number_Rows         , 32 , 5 ) )
                    * 100.00
                  , 5 , 2 )
       WHEN ( Number_Deleted_Rows > Number_Rows )
         THEN  DEC( ( DEC( Number_Rows         , 32 , 5 )
                    / DEC( Number_Deleted_Rows , 32 , 5 ) )
                    * 100.00
                  , 5 , 2 )
  END
  AS Percent_Deleted

Robert

"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 1:24 PM, rob@xxxxxxxxx wrote:
> On your first CASE, what if the number of rows = 49 and the number of
> deleted rows = 49?
>
>
> Rob Berendt