ODBC Server Reference Manual

Summary of Support for SQL Server Features
HP NonStop ODBC Server Reference Manual—429151-002
B-20
System Tables
System Tables
The NonStop ODBC Server supports some of the SQL Server system tables. The
following tables summarize NonStop ODBC Server support of the system tables.
For detailed information on how the NonStop ODBC Server supports the system
tables, see Section 8, HP NonStop ODBC Server Mapping Tables.
System Tables in All Databases
Table B-7. NonStop ODBC Server Support of System Tables in All
Databases (page 1 of 5)
Columns
Table Name NonStop ODBC Server Support Column Name NonStop ODBC Server Support Data Type Comments or Value Assigned
sysalternates – – – – –
syscolumns x id x INT (4) An object ID used internally by
the NonStop ODBC Server.
number – – Assigned 0
colid x INT (2) A number indicating the position
of the column in the row of the
table (the first column is 0).
status x INT (2) A number indicating whether the
SQL Server data type allows null
values.
type x INT (2) The SQL Server data type code.
length x INT (2) The byte length of the data in the
column.
offset x INT (2) Reserved for internal use by HP
software.
usertype x INT (2) An SQL Server user-defined
data type code.
cdefault – – Assigned -1
domain – – Assigned -1
name x CHAR (30) The column name, which is a
NonStop SQL/MP identifier.
xIndicates a supported table or column
–Indicates an unsupported table or column