Razzak: Could I also get a copy of this ? Very much appreciated, and Happy Thanksgiving. Jim
________________________________ From: A. Razzak Memon <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Wednesday, November 27, 2013 12:15 PM Subject: [RBASE-L] - Capturing Table Statistics (was Re: knowing the size of aTable) On Wed, Nov 27, 2013 at 4:52 AM, Mohammed Sattar <[email protected]> wrote: >Hi All > >How can we see the size of the Table just like we can see the >size of the database RX1…RX4 > >Mohammed Sattar >Utah Group of Companies At 06:57 AM 11/27/2013, Bill Downall wrote: >Mohammed, > >Here's a query that will give you some statistics about a >table. Name it TableStats.rmd and run it at the R> prompt: > >-- TABLESTATS.RMD > >SET VAR vTableName TEXT >SET VAR vDBName TEXT = (CVAL('DATABASE')) >SET VAR vCap TEXT = ('Tables in the database' & .vDBName) > >LABEL lbTop > >CHOOSE vTableName FROM #TBLVIEWS + >TITLE 'Choose table -- ESC to exit' + >CAPTION .vCap > >IF vTableName = '[Esc]' THEN > GOTO lbExit >ENDIF > >WRITE 'Details for table', .vTableName >SELECT Sys_Table_Type=14 as `Type`, + > Sys_Num_Columns=8 as ` Columns`, + > Sys_Num_Rows=12 as ` Rows`, + > Sys_Row_Size=8 as `Row_Size` + > FROM sys_Tables + > WHERE Sys_Table_Name = .vTableName > >GOTO lbTop > >LABEL lbExit >RETURN Mohammed, To compliment Bill Downall's CHOOSE and SELECT statements, I have created a "Variable Form" that will dynamically create a view with all statistics, including the table LOCK, ROWLOCKS, as well as the VERIFY status of any given table. Using the variable form approach, you may incorporate this form in any of your database(s). In doing so, you will be able to capture all details as Screenshot as well as PRINT all details using the following PROPERTY commands: -- To Capture the Screenshot to Windows Clipboard PROPERTY RBASE_FORM CAPTURE_FROM_WINDOW 'CLIPBOARD' -- To PRINT the form to PRINTER PROPERTY RBASE_FORM PRINT 'PRINTER' For your viewing pleasure ... http://www.Razzak.com/SampleApplications/Table_Statistics_01.jpg http://www.Razzak.com/SampleApplications/Table_Statistics_02.jpg http://www.Razzak.com/SampleApplications/Table_Statistics_03.jpg I am sending you this custom variable form (Table_Statistics) in a separate e-mail. Happy Thanksgiving! Very Best R:egards, Razzak. www.rbase.com www.facebook.com/rbase -- 30+ years of continuous innovation! 15 Years of R:BASE Technologies, Inc. making R:BASE what it is today! --
