ODBC Server Reference Manual
Summary of Support for SQL Server Features
HP NonStop ODBC Server Reference Manual—429151-002
B-21
System Tables in All Databases
printfmt – – Assigned “ ” (blank)
syscomments – – – – –
sysdepends – – – – –
sysindexes x name x VARCHAR
(60)
The fully qualified SQL Server
index name in uppercase letters.
id x INT (4) The object ID of the table.
indid x INT (2) Primary key indicator.
dpages – – Assigned -1
reserved – – Assigned -1
used – – Assigned -1
rows – – Assigned -1
first – – Assigned -1
root – – Assigned -1
distribution – – Assigned -1
usagecnt – – Assigned -1
segment – – Assigned -1
status x INT (2) Assigned -1
rowpage – – Assigned -1
minlen x INT (2) The length of the packed index
record.
maxlen – – Assigned -1
maxirow – – Assigned -1
keycnt x INT (2) The number of columns in the
index.
keys1 – – Assigned “ ” (blank)
keys2 – – Assigned “ ” (blank)
syskeys – – – – –
Table B-7. NonStop ODBC Server Support of System Tables in All
Databases (page 2 of 5)
Columns
Table Name
NonStop ODBC
Server Support
Column Name
NonStop ODBC
Server Support
Data Type
Comments or
Value Assigned
xIndicates a supported table or column
–Indicates an unsupported table or column