ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-2
Summary of Tasks
Note that in the ODBC/SQL Server view of the database in Figure 7-1, the object
names are fully qualified: for example, test_vol2_persnl.sql_kris.xemp_name.
Mapping tables also map ODBC/SQL Server system tables and data types. For a
complete description of the mapping tables, see Section 8, HP NonStop ODBC Server
Mapping Tables.
Summary of Tasks
To make a NonStop SQL/MP catalog and its associated objects available through the
NonStop ODBC Server, you must customize the catalog. You also perform
maintenance tasks that involve the catalogs and mapping tables.
Table 7-1 summarizes tasks that involve customization and mapping tables and lists
where to find that information.
Figure 7-1. A NonStop ODBC Server Mapping Table
NonStop ODBC Server
View of test_vol2_persnl
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
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
VST044.vsd