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/

Reply via email to