ODBC Server Reference Manual

HP NonStop ODBC Server Mapping Tables
HP NonStop ODBC Server Reference Manual—429151-002
8-67
SYSOBJECTS Catalog Table (ZVUOBJ)
SYSOBJECTS Catalog Table (ZVUOBJ)
The catalog view SYSOBJECTS lists the tables and views in a NonStop SQL/MP
Catalog.
It includes user and SQL Server system tables but does not include stored procedures.
SYSOBJECTS is represented by a join view over TABLES and mapping tables. The
view and mapping tables reside on each customized subvolume.
Sequence of rows is ascending by UID and NAME.
Each partition of a partitioned table is mapped to a distinct qualified TSQL table name
without regard to the catalogs in which the partitions are registered. Therefore, you can
access the same underlying NonStop SQL/MP table through multiple TSQL tables.
Table 8-35 lists and describes the columns in SYSOBJECTS. NonStop SQL/MP
Catalog tables appear in the description as user tables.
Table 8-35. Description of SYSOBJECTS (page 1 of 2)
Column Name
Column Name in ZNUOBJ,
ZNSUS, or TABLES Description
NAME ZNUOBJ.TABLENAME Fully qualified ODBC or SQL Server
object name in uppercase letters.
ID None Object ID used internally by the
NonStop ODBC Server. Value is
unique.
UID ZNSUS.NOS_UID User ID used internally by the
NonStop ODBC Server.
TYPE TABLES.TABLETYPE or “P”
if the NAME is a stored
procedure.
Code indicating the object type:
N NonStop SQL/MP catalog
table or NonStop ODBC
Server mapping table
S System table view
T Temporary table
UUser table
VView
USERSTAT None No corresponding column name.
Assigned –1.
SYSSTAT None No corresponding column name.
Assigned –1.
INDEXDEL None No corresponding column name.
Assigned –1.
SCHEMA None No corresponding column name.
Assigned –1.