ODBC Server Reference Manual

HP NonStop ODBC Server Reference Manual—429151-002
8-1
8
HP NonStop ODBC Server Mapping
Tables
The HP NonStop ODBC Server acts as a gateway to HP NonStop SQL/MP from
external entities. As such, it must provide translation from external concepts and
protocols to NonStop SQL/MP concepts and protocols. The NonStop ODBC Server
creates and maintains a set of tables, views, and indexes called the NonStop ODBC
Server mapping tables. Although the mapping tables are composed of views and
indexes as well as tables, and although some are involved in mapping and provide
support, all are collectively called mapping tables. The tables that do the actual
mapping map ODBC or SQL Server names and data types to NonStop SQL/MP
names and data types.
This section describes all of the tables, views, and indexes and the actions that can
affect them. It includes the following information:
•
Types of mapping
•
Summary of the mapping tables
•
Database and object mapping
•
System table mapping
•
Actions that affect mapping tables
Customized catalogs and the catalog utilities are described in Section 7, Managing
Customized Catalogs.
Figure 8-1 shows a customized NonStop SQL/MP catalog (\TEST.$VOL2.PERSNL)
and a portion of the table that maps the NonStop ODBC Server or SQL Server object
names to NonStop SQL/MP object names.