HP 3000 Manuals HP 3000 Manuals
DETACH
Detaches a TurboIMAGE/XL database from a DBEnvironment.
Syntax
DET[ACH]
Command Prerequisites
* SET SQLDBE issued.
* SET TURBODB issued.
* DBA authority.
* Database attached.
Description
Use the DETACH command to detach a TurboIMAGE/XL database from a
DBEnvironment. SET TURBODB and SET SQLDBE commands must be issued before
the detach can take place. The database named in the most recent SET
TURBODB is detached from the DBEnvironment named in the most recent SET
SQLDBE command.
You must detach the database before performing any restructuring tasks
and reattach when the restructuring is complete.
When a database is detached, all mapping information about it is removed
from the ATCINFO file. If it is the only database attached to the
DBEnvironment, the ATCINFO file itself is purged. If the TurboIMAGE/XL
database is no longer attached to any DBEnvironment, the DBNameTC file is
also purged.
In addition, all mapped table definitions are removed from the
DBEnvironment system catalog. All IMAGE/SQL views and user-created views
based on IMAGE/SQL tables and views are dropped. Note that DBUTIL can be
used to purge and detach a database that is attached to a DBEnvironment.
Example
In this example, SALES is detached from PartsDBE. When this occurs, all
mapping information about SALES is removed from the ATCINFO file. If
SALES is the only database attached to PartsDBE, the ATCINFO file itself
is purged. If SALES is no longer attached to any DBEnvironment, the
SALESTC file is also purged.
_____________________________________
| |
| >>SET SQLDBE PARTSDBE |
| >>SET TURBODB SALES |
| >>DETACH |
| >> |
_____________________________________