ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-23
SYSCAT DEINSTALL Statement
You can run SYSCAT DEINSTALL only from a NOSCOM prompt; it cannot be run as a
NonStop ODBC Server pass-through command.
SYSCAT DEINSTALL has the following syntax:
RESTRICT
empties the catalog mapping tables before the tables are dropped. This option is
the default. SYSCAT DEINSTALL with the RESTRICT option succeeds only if the
NonStop ODBC Server mapping table ZNSDB contains the entry for MASTER, and
no other information; and if entries in ZNUOBJ represent only system objects.
CASCADE
drops all NonStop ODBC Server objects referenced in the system catalog mapping
tables before dropping the mapping tables. A NonStop ODBC Server object is an
object that was created through the NonStop ODBC Server using CORE SQL or
Transact-SQL statements.
If you omit CASCADE, all objects are retained.
Example
The following statement decustomizes the NonStop SQL/MP system catalog:
SYSCAT DEINSTALL
Effects of SYSCAT DEINSTALL
SYSCAT DEINSTALL does the following:
•
Drops all of the mapping tables in the subvolume of the system catalog.
•
Drops objects created using the NonStop ODBC Server, if you specify CASCADE.
•
Runs under a separate TMF transaction. The NOSUTIL program automatically
commits the transaction after decustomizing the system catalog.
•
Preserves the actual NonStop SQL/MP system catalog. You must use the NonStop
SQL/MP Conversational Interface to drop the system catalog.
•
Generates an error if you are not a privileged user.
•
Generates an error if the system catalog is not customized for the NonStop ODBC
Server. However, you can deinstall a system catalog customized by an earlier
version of the NonStop ODBC Server.
•
Because of the TMF response time, it might take a few minutes before the catalog
tables are released from the locks. Therefore, if you perform an INSTALL
immediately after a DEINSTALL, a failure might occur because of these locks. If
this happens, wait a few minutes and then retry the INSTALL.
SYSCAT DEINSTALL [ RESTRICT | CASCADE ]