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!
--
--- 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=
