Thank you to all, Razzak, Troy, Bill, and Richard for your quick reply and helping Hand!

Herb

 

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of A. Razzak Memon
Sent: May 30, 2002 11:39 AM
To: [EMAIL PROTECTED]
Subject: Re: Unload and Reload syntax - Razzak's Reply

 


At 10:46 AM 5/30/2002 -0400, Herbert Hemberger wrote:


I would like to unload and Reload 2 small databases and I
seem to have problems with the syntax. I use Rbase 6.5 ++
for Windows with both online patches. My O/S is WinXP Pro
on a single box.

An example would be appreciated, since I�m a novice.



Herbert,

Simple example of  UNLOAD:

At the mighty R> prompt or in a command file:

SET MULTI OFF
CONNect  DBName IDENTIFIED BY ownerpassword
SET NULL -0-
OUTP DBBackup.UNL
UNLOAD ALL
OUTP SCREEN
DISConnect
DELETE DbBackup.RB?
RENAME DBName.RB? DBBackup.RB?
INPUT DBBackup.UNL
DISConnect
SET MULTI ON
CONNect  DBName IDENTIFIED BY ownerpassword

Simple example of  RELOAD:

At the mighty R> prompt or in a command file:

SET MULTI OFF
CONNect  DBName IDENTIFIED BY ownerpassword
DELETE DbBackup.RB?
RELOAD DbBackup
DISConnect
DELETE DBName.RB?
RENAME DBBackup.RB? DBName.RB?
SET MULTI ON
CONNect  DBName IDENTIFIED BY ownerpassword

Other references:

Check out the correct  syntax on: http://www.RSyntax.com

>From The Edge: http://www.razzak.com/fte (Powered by R:Tango)
There, you will also find a few technical documents.

Should you require further assistance, please feel free to ask your questions
on this list.

Enjoy and make sure to have fun with TGRB2000 (ver 6.5++) for Windows!

Very Best Regards,

Razzak.

Reply via email to