ODBC Server Reference Manual

HP NonStop ODBC Server Mapping Tables
HP NonStop ODBC Server Reference Manual—429151-002
8-64
SYSINDEXES Catalog View (ZVUIX)
SYSINDEXES Catalog View (ZVUIX)
The catalog view SYSINDEXES is defined for TSQL mode only. It lists the indexes in a
NonStop SQL/MP catalog that are created by NonStop ODBC Server users. Indexes
created by HP server users that are on tables in other catalogs are not visible through
SYSINDEXES.
SYSINDEXES is represented by a view over INDEXES and a mapping table. The view
and mapping tables reside on each customized subvolume.
Sequence of rows is ascending by ID and NAME.
SYSINDEXES is updated when a NonStop ODBC Server user issues a CREATE or
DROP INDEX statement.
The SQL Server catalog table SYSKEYS is not supported with a specific view, but is
instead satisfied with an SQL query generated by the driver directly against the
mapping and catalog tables.
Table 8-33. Description of SYSINDEXES (page 1 of 2)
Column Name
Column Name in ZNUIX or
INDEXES Description
NAME ZNUIX.T_INAME the fully qualified ODBC or SQL
Server index name in uppercase
letters.
ID ZNUIX.T_TABLEID A random number generated by the
system.
INDID INDEXES.KEYTAG + 1 Primary key indicator.
DPAGES None No corresponding column name.
Assigned –1.
RESERVED None No corresponding column name.
Assigned –1.
USED None No corresponding column name.
Assigned –1.
ROWS None No corresponding column name.
Assigned –1.
FIRST None No corresponding column name.
Assigned –1.
ROOT None No corresponding column name.
Assigned –1.
DISTRIBUTION None No corresponding column name.
Assigned –1.
USAGECNT None No corresponding column name.
Assigned –1.
SEGMENT None No corresponding column name.
Assigned –1.