ODBC Server Reference Manual

HP NonStop ODBC Server Reference Manual—429151-002
7-1
7
Managing Customized Catalogs
A customized catalog is a HP NonStop SQL/MP catalog available through the HP
NonStop ODBC Server. To make the customized catalog available, the NonStop ODBC
Server creates special tables to map ODBC/SQL Server objects and data types to
NonStop SQL/MP objects and data types or to Pathway objects. You will occasionally
need to access these mapping tables to locate objects or to perform maintenance
tasks.
A customized catalog corresponds to an ODBC/SQL Server database.
This section explains what customization tasks you need to perform and when to
perform these tasks. The section covers the following topics:
•
Reasons to access the mapping tables
•
Locating objects using the mapping tables
•
Renaming ODBC/SQL Server objects
•
Running the catalog utility statements
•
Customizing the system catalog—SYSCAT INSTALL
•
Customizing a user catalog—USERCAT INSTALL
•
Decustomizing the system catalog—SYSCAT DEINSTALL
•
Decustomizing a user catalog—USERCAT DEINSTALL
•
Adding objects to the mapping tables, removing extraneous mapping entries, and
rebuilding mapping tables—SYSCAT REFRESH and USERCAT REFRESH
•
Reporting referential inconsistencies—SYSCAT VALIDATE and USERCAT
VALIDATE
•
Dropping temporary objects—CLEANUP
•
Upgrading catalogs to the current version—SYSCAT UPGRADE and USERCAT
UPGRADE
•
Adding, changing, and deleting mapping and configuration entities with the
mapping table statements listed in Table 7-4 on page 7-38
Figure 7-1 illustrates a customized NonStop SQL/MP catalog, PERSNL, and a portion
of the table that maps the customized objects to ODBC/SQL Server object names.