Jan,
What you can also do is run with STATICDB ON, and then SCONNECT/SATTACH as required. This makes the SATTACH temporary, and is automatically removed when you disconnect the database.
Buddy,
Good advice. I think this is information I was originally looking for.
In order to skirt the 2G limit in RBase I needed to move this table (800MB) externally. However everyone still needs access to it and I really need to think about the Multi-userness here.
Jan
----- Original Message ----- From: "Walker, Buddy" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> Sent: Tuesday, November 02, 2004 9:03 AM Subject: [RBG7-L] - Re: odbc
Jan Be careful about sdetaching a table in your exit block. The reason is if you have 5 individuals using the database and need access to the sattached table it would be lost. What I do in that case is sconnect then check and see if table is already sattached if so do nothing otherwise issue the sattach. Now this is assuming that everyone uses the same exit block.
Buddy
-----Original Message----- From: Jan Johansen [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 02, 2004 11:24 AM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: odbc
Thank you for the clarification. I will do the detaching in my exit block.
Jan
Emmitt Dove Manager, DairyPak Business Systems Blue Ridge Paper Products, Inc. 40 Lindeman Drive Trumbull, CT 06611 (203) 673-2231 [EMAIL PROTECTED] [EMAIL PROTECTED]
