ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-22
Decustomizing Catalogs
If an error occurs during USERCAT INSTALL, then one of the following occurs:
•
If the original catalog was a user catalog customized for the NonStop ODBC
Server, then after USERCAT REFRESH fails, the original NonStop ODBC Server
customized user catalog is restored.
•
If the original catalog was a NonStop SQL/MP user catalog, then after USERCAT
INSTALL fails, the NonStop SQL/MP user catalog is restored.
•
If there was no original NonStop SQL/MP user catalog catalog-name, then no
NonStop SQL/MP user catalog remains after USERCAT INSTALL fails.
How Object Names Are Assigned
When you customize or refresh a system catalog or user catalog, the NonStop ODBC
Server assigns ODBC/SQL Server names to the objects in the catalog. The NonStop
ODBC Server usually assigns the Guardian file name. For example, a NonStop
SQL/MP table named \TESS.$NOSS.PERSNL.EMPLOYEE is given the ODBC/SQL
Server name EMPLOYEE. Sometimes, however, the NonStop ODBC Server must
assign a name other than the Guardian file name.
For information about viewing and changing the mapped names, see Renaming ODBC
or SQL Server Objects on page 7-7.
How Owner Names Are Assigned
The owner name for the objects is the same as the owner of the corresponding
Guardian file. The owner name of the mapping tables is the user who customizes the
catalog.
Decustomizing Catalogs
The following describes SYSCAT DEINSTALL and USERCAT DEINSTALL, which
decustomize the system catalog and user catalogs, respectively.
SYSCAT DEINSTALL Statement
Use the SYSCAT DEINSTALL statement to decustomize the system catalog. SYSCAT
DEINSTALL drops all of the mapping tables from the system catalog and, optionally,
drops all objects created using the NonStop ODBC Server. You must be a privileged
user to run SYSCAT DEINSTALL.
When you no longer need the NonStop ODBC Server installed on your system, you
decustomize the system catalog. When you decustomize the system catalog, all
NonStop ODBC Server mapping tables are purged from the subvolume containing the
NonStop SQL/MP system catalog.
Before decustomizing the system catalog, you must decustomize every customized
catalog by using USERCAT DEINSTALL.