ODBC Server Reference Manual

Architecture Overview
HP NonStop ODBC Server Reference Manual—429151-002
2-25
NonStop ODBC Server Catalogs
Client Catalogs
A previous description showed how the NonStop ODBC Server catalogs are used by
the NonStop ODBC server to map client names to NonStop SQL/MP names. The other
main use of the NonStop ODBC Server catalogs is to support client SQL catalogs for
TSQL and CORE SQL users.
TSQL Catalogs
For TSQL users, SQL Server supports several SQL catalog tables for user and system
catalogs. DBLIB clients typically access a subset of these tables in their applications.
Figure 2-21 shows how the TSQL catalog SYSOBJECTS is supported using the
NonStop SQL/MP catalog table TABLES and the NonStop ODBC Server user catalog
table ZNUOBJ (only enough columns of SYSOBJECTS are shown to illustrate the
techniques).
ZVUOBJ is a NonStop SQL/MP view on the join of tables TABLES and ZNUOBJ.
SYSOBJECTS is a TSQL table whose name is mapped to ZVUOBJ (so ZNUOBJ
contains another entry for the mapping between SYSOBJECTS and ZVUOBJ, not
shown here).
ZNSUMAP Map login username and SCS to server class
ZNSUS Map logical usernames to Guardian usernames
ZNSVALUE Help support SYSVALUES for TSQL
ZNUx All tables of a NonStop ODBC Server user catalog
Table Usage