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!
--
--- RBASE-L
=======================3D=======================3
D=
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
=======================3D=======================3
D=
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
=======================3D=======================3
D=
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
=======================3D=======================3
D=
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
=======================3D=======================3
D=
