ODBC Server Reference Manual

Architecture Overview
HP NonStop ODBC Server Reference Manual—429151-002
2-23
NonStop ODBC Server Catalogs
function. There may be zero or more NonStop ODBC customized user catalogs on a
system. Each customized user catalog is registered in one or more NonStop ODBC
system catalogs. The NonStop ODBC Server system catalog, which must exist if there
are any NonStop ODBC Server objects on the node, includes a NonStop ODBC Server
user catalog.
Figure 2-20 shows an example of NonStop ODBC Server catalogs. Subvolume
$SYSTEM.SQL on node \N3 contains the NonStop SQL/MP system catalog and the
NonStop ODBC Server system catalog. $VOL.SUB1 contains a NonStop SQL/MP
catalog and a NonStop ODBC Server user catalog. $VOL.SUB2 contains a NonStop
SQL/MP catalog, but no NonStop ODBC Server user catalog.
The names of all the NonStop ODBC Server catalog tables start with “ZN” to minimize
conflicts with user naming. In this figure, clients would access databases named
MASTER and N3_VOL_SUB1. The system catalog is always named MASTER, which
follows SQL Server conventions.
Figure 2-20. NonStop ODBC Server Catalogs
$VOL.SUB1
Tables
Columns...
NonStop SQL User Catalog
Tables
Columns...
Catalogs
Tables...
ZNUOBJ
Z...
ZNSDB
Z...
$VOL.SUB2
NonStop ODBC Server
System Catalog
NonStop SQL System Catalog
NonStop ODBC Server
User Catalog
ZNUOBJ
Z...
NonStop SQL User Catalog
$System.SQL
Node \N3
VST024.vsd