Razzak, Would you mind sending me a copy of this as well?
James Belisle Making Information Systems People Friendly Since 1990 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of A. Razzak Memon Sent: Thursday, November 28, 2013 2:27 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Capturing Table Statistics (was Re:knowing the size of aTable) At 02:17 PM 11/28/2013, Jim Schmitt wrote: >Razzak: > >Could I also get a copy of this ? Very much appreciated, and Happy >Thanksgiving. My pleasure, Jim! You have mail. And, Happy Thanksgiving to you as well. Very Best R:egards, Razzak >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 ><<mailto:[email protected]>[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_01.jpg > >http://www.Razzak.com/SampleApplications/Table_Statistics_02.jpg > ><http://www.razzak.com/SampleApplications/Table_Statistics_03.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! >--
