midrange.com code scratchpad
Name:
Re: Need assistance with SQL statement over QSYS2.SYSTABLESTAT
Scriptlanguage:
Plain Text
Tabwidth:
4
Date:
09/17/2013 07:35:01 pm
IP:
Logged
Description:
The user was to lazy to give a description
Code:
  1. SELECT
  2.   Table_Schema        AS Table_Schema
  3. , Table_Name          AS Table_Name
  4. , Number_Rows         AS Number_Rows
  5. , Number_Deleted_Rows AS Number_Deleted_Rows
  6. , CAST(CASE
  7.          WHEN ( Number_Deleted_Rows = 0 )                         THEN   0
  8.          WHEN ( Number_Rows = 0 ) AND ( Number_Deleted_Rows > 0 ) THEN 100.00
  9.          ELSE ( 100.00 *  Number_Deleted_Rows / ( Number_Rows + Number_Deleted_Rows ) )
  10.        END
  11.        AS DECIMAL( 5 , 2 )
  12.       ) AS Percent_Deleted
  13. , Data_Size AS Data_Size
  14. , COALESCE( CHAR( DATE( Last_Used_Timestamp    ) ), ' ' ) AS Last_Used
  15. , COALESCE( CHAR( DATE( Last_Change_Timestamp  ) ), ' ' ) AS Last_Chgd
  16. , COALESCE( CHAR( DATE( Last_Save_Timestamp    ) ), ' ' ) AS Last_Saved
  17. , COALESCE( CHAR( DATE( Last_Restore_Timestamp ) ), ' ' ) AS Last_Restored
  18. FROM   qsys2.systablestat
  19. WHERE Table_Schema = 'MyLIB'  -- Use your actual schema name here, etc.
  20.  
© 2004-2019 by midrange.com generated in 0.006s valid xhtml & css