ODBC Server Reference Manual

HP NonStop ODBC Server Mapping Tables
HP NonStop ODBC Server Reference Manual—429151-002
8-3
System Table Mapping
System Table Mapping
The NonStop ODBC Server maintains tables and views that correspond to the SQL
Server system tables. When you specify a system table name, the NonStop ODBC
Server searches the object mapping table, ZNUOBJ, and locates the view name that
corresponds to the system table.
For more information, see System Table Mapping on page 8-60.
Summary of the Mapping Tables
The mapping tables reside in the following subvolumes:
•
The subvolume of the system catalog. These mapping tables are created when
you install the NonStop ODBC Server.
•
The subvolume of a customized user catalog. The NonStop ODBC Server creates
these mapping tables when an existing catalog is customized or when a database
is created using the NonStop ODBC Server.
Naming Conventions
Object name prefixes provide information about the object. “ZN” indicates a base table
or index used by the NonStop ODBC Server to simulate TSQL and ODBC catalog
structures on a NonStop SQL catalog. “ZV” indicates a view provided by the NonStop
ODBC Server to simulate TSQL and ODBC catalog structures on a NonStop SQL
catalog.
The prefixes in Table 8-1 indicate the object type and the location of the object.
For example, ZVSDB is a view in the subvolume of the system catalog, and ZNUOBJ
is a table in both the subvolume of the system catalog and the customized user
catalogs.
Prefixes for column names contain information about column values, as described in
Table 8-2.
Table 8-1. Naming Conventions for the Mapping Tables
Location
Prefix Object Type
Subvolume of the
System Catalog
Subvolume of the
User Catalog
ZNS Table or index x –
ZNU Table or index x x
ZVS View x –
ZVU View x x
x Indicates the object exists in this catalog
– Indicates the object does not exist in this catalog