ODBC Server Reference Manual

HP NonStop ODBC Server Mapping Tables
HP NonStop ODBC Server Reference Manual—429151-002
8-2
Types of Mapping
Types of Mapping
The NonStop ODBC Server maps database names, object names, and system table
names. The mapping is invisible to the user: users specify ODBC or SQL Server
names, and the NonStop ODBC Server locates the corresponding NonStop SQL/MP
name by using the mapping tables.
Database and Object Mapping
The NonStop ODBC Server maintains three mapping tables listing all databases,
indexes, tables, and views for a customized catalog:
When you specify an ODBC or SQL Server object name, the NonStop ODBC Server
searches the corresponding mapping table and locates the NonStop SQL/MP name for
that object.
For more information, see Database and Object Mapping on page 8-8.
Figure 8-1. A NonStop ODBC Server Mapping Table
Mapping Table Objects Mapped
ZNSDB Databases
ZNUIX Indexes
ZNUOBJ Tables and views
employee
department
employee_list
xemp_name
• • •
System Tables
syscolumns
sysindexes
sysobjects
User Tables
employee
departme
empl4987
xempunam
• • •
Mapping Tables
ZVUCOL
ZVUIX
ZVUOBJ
User Tables
NonStop SQL/MP
Catalog \test.$vol2.persnl
NonStop ODBC Server
View of test_vol2_persnl
Sample Mapping Table
dbo
dbo
dbo
sql_james
sql_james
sql_kris
sql_kris
syscolumns
sysindexes
sysobjects
employee
department
employee_list
xemp_name
\test.$vol2.persnl.zvucol
\test.$vol2.persnl.zvuix
\test.$vol2.persnl.zvuobj
\test.$vol2.persnl.employee
\test.$vol2.persnd.departme
\test.$vol2.persnl.empl4987
\test.$vol2.persnl.xempunam
Owner
SQL Server /
ODBC Name
NonStop
SQL/MP Name
VST046.vsd