ODBC Server Reference Manual

HP NonStop ODBC Server Mapping Tables

HP NonStop ODBC Server Reference Manual—429151-002

8-63

SYSDATABASES Catalog View (ZVSDB)

The catalog view SYSDATABASES represents the customized NonStop SQL/MP

catalogs on a node. It is supported by a view over a mapping table. It is updated when

a NonStop ODBC Server user issues a CREATE or DROP DATABASE statement or

the equivalent statement for USERCAT INSTALL or USERCAT DEINSTALL.

SYSDATABASES exists only with the NonStop SQL/MP system catalog that

corresponds to the MASTER database. The MASTER database is assigned to the

customized SQL system catalog for the given node.

Table 8-32. Description of SYSDATABASES

Column Name

Column Name in ZNSDB or

CATALOGS Description

NAME ZNSDB.T_DBNAME Fully qualified ODBC or SQL Server

database name in uppercase letters.

DBID ZNSDB.T_DBID Internal ID used by the NonStop

ODBC Server to satisfy requirements

of TSQL users.

SUID ZNSDB.T_CREATOR ODBC or SQL Server user ID of the

database creator. If the database is

created in NonStop SQL/MP and then

customized, the creator is the user ID

of the user who customizes the

catalog.

MODE None No corresponding column name.

Assigned –1.

STATUS None No corresponding column name.

Assigned –1.

VERSION ZNSDB.T_VERSION NonStop ODBC Server version

number.

CRDATE CATALOGS.CREATETIME Date and time the catalog was

created or customized.