RE: Unload all/Reload/ Pack

[Gunnar Ekblad]

Thanks
Sounds very much like what I do. I did say delete but of cource I have a
backup (in fact at least 3 Tape, my own C-drive plus the renamed db on
the network)
But yet I have experienced problem with 
         output filename.all
         unload all
         output screen
         disconnect
         rename db.rb* olddb.rb*
         run filename.all
where some of the tables come back with zero entries as compared to
reload where the enries is not gone.
Gunnar




-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
On Behalf Of Emmitt Dove
Sent: den 11 december 2002 19:34
To: [EMAIL PROTECTED]
Subject: Re: Unload all/Reload/ Pack


Gunnar,

What we do is:

         output filename.all
         unload all
         output screen
         disconnect
         rename db.rb* olddb.rb*
         run filename.alll

The key here is the rename of the database rather than a delete.  Only 
caveat is that you must be sure that "olddb.rb*" does not exist in the 
current directory; otherwise, when you "run filename.all" you'll be 
duplicating your data.  But this technique leaves the original database 
intact in case the process fails somehow.  All you have to do then is 
rename it back to the original name.

>Has someone a guidence?
>1. If I do a pack I understand I take a chance on no power breakdown.
>2. If I do a reload I should not have the risk of power breakdown but
>have the same result as 1 obove.
>3. If I do unload all then delete the database base an load it back,
>that should be the same as 2 obove.!?
>4. If 2 and 3 and that does not give the same result what am I doing
>wrong?
>5. I am mostly on DOS 1.862 (or Windows corresponding version)
>Background:
>1. I am doing conversion work from Glorious 2.11 to Dos version of
today
>waiting for the future win 7.0 to go Windows when happy days will
>arrive.
>Other minory ? that I can not answer!
>1. Has someone an Idea where I can look for answers?
>2. Has anyone an Idea what to look out four?
>Not to worry!
>1. Some 20 % of my application is running on 1.862 but I would be happy
>to understand above subject before I Move remaining 80% from 2.11
>
>??? From the Swedish Dinosaur of 2.11 world ???
>Gunnar
>

Emmitt Dove
Manager, DairyPak Business Systems
Blue Ridge Paper Products, Inc.
40 Lindeman Drive
Trumbull, CT  06611
(203) 673-2231
[EMAIL PROTECTED]
[EMAIL PROTECTED]

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