ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-13
Running the Catalog Utility Statements
Running the Catalog Utility Statements
The NonStop ODBC Server provides utilities for managing the NonStop ODBC Server
mapping tables. Access the utility statements in one of three ways:
•
From a TACL prompt by running the program NOSCOM
•
From the NonStop ODBC Server Configuration Manager, a graphical user interface
tool
•
By using pass-through mode in the NonStop ODBC Server
Most catalog utility statements can be executed by using the NonStop ODBC Server,
but some statements must be executed from the NonStop ODBC Server Configuration
Manager or a NOSCOM prompt.
Table 7-3. Catalog Utility Statements
Statement Description
Execute By
Using NonStop
ODBC Server
SYSCAT INSTALL Customizes the NonStop SQL/MP
system catalog.
–
USERCAT INSTALL Customizes a NonStop SQL/MP user
catalog.
x
SYSCAT DEINSTALL Decustomizes the NonStop SQL/MP
system catalog.
–
USERCAT DEINSTALL Decustomizes a NonStop SQL/MP user
catalog.
x
SYSCAT REFRESH and
USERCAT REFRESH
Add NonStop SQL/MP objects to the
mapping tables, remove unresolved
object references, re-create missing
mapping tables and mapping table
items.
x
SYSCAT VALIDATE and
USERCAT VALIDATE
Report all referential inconsistencies
with the mapping tables.
x
CLEANUP Drops temporary objects and removes
them from the mapping tables.
x
SYSCAT UPGRADE and
USERCAT UPGRADE
Upgrade catalogs to the current version. x
Mapping table statements
listed in Table 7-4
Create, modify, and delete items in the
mapping tables.
x
? Displays the syntax of the utility
statements.
–
x Indicates the statement can be executed using the NonStop ODBC Server
– Indicates the statement cannot be executed using the NonStop ODBC Server