ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-4
Locating Objects Using the Mapping Tables
Locating Objects Using the Mapping Tables
You will sometimes need to use the mapping tables to locate objects. Because the
mapping tables map ODBC/SQL Server object names to NonStop SQL/MP file names,
you might need information from the mapping table in the following cases:
•
To list all customized catalogs
•
To determine the file name of a table so you can use the table name with NonStop
SQL/MP statements or pass-through statements
•
To determine the ODBC/SQL Server name of an object you created by using
NonStop SQL/MP then added to the mapping tables by refreshing them
List all NonStop
SQL/MP catalogs
available through the
NonStop ODBC
Server
Check the mapping table that
corresponds to the ODBC/SQL
Server system table
SYSDATABASES.
Locating Objects Using the
Mapping Tables on page 7-4
Recover a mapping
table that you
accidentally purged
Rebuild the mapping tables. SYSCAT REFRESH
Statement on page 7-27 and
USERCAT REFRESH
Statement on page 7-29
Use new features of
the NonStop ODBC
Server
First, upgrade the catalogs to the
version that provides support for
those features.
SYSCAT UPGRADE
Statement on page 7-36 and
USERCAT UPGRADE
Statement on page 7-37
Remove the
customization so the
catalog is no longer
available through the
NonStop ODBC
Server
Decustomize the catalog. SYSCAT DEINSTALL
Statement on page 7-22 and
USERCAT DEINSTALL
Statement on page 7-24
Drop a customized
catalog using NonStop
SQL/MP
The catalog will still be listed in the
mapping tables, so you must
refresh the system catalog.
SYSCAT REFRESH
Statement on page 7-27 and
USERCAT REFRESH
Statement on page 7-29
Table 7-1. Tasks That Involve Customization and Catalog Utilities (page 2 of 2)
Task What You Need to Do
Where to Find Further
Information