ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-26
USERCAT DEINSTALL Statement
If the catalog contains objects created by using NonStop SQL/MP, the mapping tables
and NonStop ODBC Server objects are dropped, but the catalog is not dropped. A
warning is displayed indicating that the catalog is not empty and was not dropped.
Effects of USERCAT DEINSTALL
USERCAT DEINSTALL does the following:
•
Drops all the NonStop ODBC Server mapping tables from your catalog subvolume.
•
Removes your catalog entry from the customized system catalog (which
corresponds to SYSDATABASES).
•
Drops all objects created using the NonStop ODBC Server (if you specify
CASCADE or CASCADE_NSSQL).
•
Removes all entries in ZNUOBJ that refer to remaining NonStop ODBC Server
objects. If you later execute a USERCAT INSTALL command, object names longer
than 8 characters will be truncated.
•
Drops the NonStop SQL/MP catalog (if you specify CASCADE_NSSQL and the
catalog is empty).
•
Generates an error if the user catalog is not customized for the NonStop ODBC
Server.The action described is conditional, succeeding if the user has the privilege
to add a user. It will fail to complete if the user is not privileged and one or more
objects have owners not currently registered in the system catalog.
•
The action described is conditional, succeeding if the user has the privileges to add
a user. It will fail to complete if the user is not privileged and one or more objects
have owners not currently registered in the system catalog.
If USERCAT DEINSTALL fails with CASCADE specified, either explicitly or by default,
the user catalog is unchanged.
Dropping Tables With Dependent Views
If you specify the CASCADE or CASCADE NSSQL keywords, USERCAT DEINSTALL
drops objects in the order in which they are listed in the mapping tables. If a view is
dependent on a table and the table is listed in the mapping table before the view,
USERCAT DEINSTALL drops the table before dropping the dependent view. When
dropping the table, NonStop SQL/MP also drops the dependent view; however, the
view remains listed in the mapping tables.
When USERCAT DEINSTALL encounters the view in the mapping table, it attempts to
drop it, and the following messages are generated:
NOSUTIL warning: DROP VIEW view-name failed. Sqlcode = -4059
NOSUTIL error: File system error 11
You can ignore these messages because the view has already been dropped.