Al
That sounds like a VERY useful routine - would you be willing to share it?
David Blocker
----- Original Message -----
From: "Albert Berry" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, December 12, 2002 3:27 PM
Subject: Re: Unload all/Reload/ Pack
At PSD we create a small database on the fly, unload the table names and row
counts from sys_tables (deliberately including the SYS_ tables, because that
way we know if any indexes or constraints don't make it) from the before and
after databases and load them into the new database and compare the
rowcounts. We do this after every reload.
I don't know who originally wrote the routines, they predate me, but they
are now in my permanent repertoire.
"J.M. GRATIAS" <[EMAIL PROTECTED]> wrote:
>
>Randy :
>
>>>
>Do you have a slick way of doing this? Or do you output a
>list command to the printer, and physically compare the lists?
><<
>
>This will count the total number of rows :
>
>-- Comptage nb total d'enreg. avant installation
>SELECT SUM(sys_num_rows) INTO vnbenr1 FROM sys_tables +
> WHERE Sys_Table_Type = 'TABLE' AND Sys_Table_Name NOT IN
>('aide','popup')
>
>I add a WHERE clause because in my case I need to exclude some tables from
>the count.
>
>Do that before and after UNLOAD/RELOAD and compare results....
>
>J.M. GRATIAS, Logimatique
>================================================
>TO SEE MESSAGE POSTING GUIDELINES:
>Send a plain text email to [EMAIL PROTECTED]
>In the message body, put just two words: INTRO rbase-l
>================================================
>TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
>In the message body, put just two words: UNSUBSCRIBE rbase-l
>================================================
>TO SEARCH ARCHIVES:
>http://www.mail-archive.com/rbase-l%40sonetmail.com/
>
--
Albert Berry
Full Time Consultant to
PSD Solutions
350 West Hubbard, Suite 210
Chicago, IL 60610
312-828-9253 Ext. 32
__________________________________________________________________
The NEW Netscape 7.0 browser is now available. Upgrade now!
http://channels.netscape.com/ns/browsers/download.jsp
Get your own FREE, personal Netscape Mail account today at
http://webmail.netscape.com/
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: INTRO rbase-l
================================================
TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: UNSUBSCRIBE rbase-l
================================================
TO SEARCH ARCHIVES:
http://www.mail-archive.com/rbase-l%40sonetmail.com/
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: INTRO rbase-l
================================================
TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: UNSUBSCRIBE rbase-l
================================================
TO SEARCH ARCHIVES:
http://www.mail-archive.com/rbase-l%40sonetmail.com/
