At 04:10 PM 12/4/2013, Jim Belisle wrote:
Razzak,
Would you mind sending me a copy of this as well?
Jim,
You have mail.
Enjoy!
Razzak.
-----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!
>--
