ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-25
USERCAT DEINSTALL Statement
CASCADE
drops all NonStop ODBC Server objects registered in catalog-name before
dropping the mapping tables. A NonStop ODBC Server object is an object created
through the NonStop ODBC Server using CORE SQL or Transact-SQL statements.
The underlying NonStop SQL/MP table is unaffected.
If you specify CASCADE, you must also specify catalog-name.
CASCADE_NSSQL
drops both the NonStop ODBC Server objects and the NonStop SQL/MP catalog, if
there are no NonStop SQL/MP objects in the catalog after removing the NonStop
ODBC Server objects. If you specify CASCADE_NSSQL, you must specify
catalog-name.
The catalog must be empty of all tables in order to drop it.
Examples
The following examples show uses of USERCAT DEINSTALL.
Do Not Drop Any Objects
The following statement decustomizes the NonStop SQL/MP catalog
\TEST.$VOL2.PERSNL:
usercat deinstall \test.$vol2.persnl restrict
If any NonStop ODBC Server objects exist, the catalog is not deinstalled; if there are
no NonStop ODBC Server objects, the mapping tables are dropped.
Drop Objects Created By Using the NonStop ODBC Server
The following statement decustomizes the NonStop SQL/MP catalog
\TEST.$VOL2.SALES:
usercat deinstall \test.$vol2.sales
Use this statement, in which the CASCADE keyword is assumed by default, to drop the
NonStop ODBC Server mapping tables and all objects that were created by using the
NonStop ODBC Server. Objects created by using NonStop SQL/MP remain in the
catalog.
Drop the NonStop SQL/MP Catalog and Objects Created With the NonStop
ODBC Server
The following decustomizes the NonStop SQL/MP catalog \TEST.$VOL2.INVENT:
usercat deinstall \test.$vol2.invent cascade_nssql
Use this statement to drop the NonStop ODBC Server mapping tables, all objects that
were created by using the NonStop ODBC Server, and the NonStop SQL/MP catalog.