ODBC Server Reference Manual

Summary of Support for SQL Server Features
HP NonStop ODBC Server Reference Manual—429151-002
B-25
System Tables in the Master Database
System Tables in the Master Database
Table B-8. NonStop ODBC Server Support of System Tables in the Master
Database Only (page 1 of 2)
Columns
Table Name NonStop ODBC Server Support Column Name NonStop ODBC Server Support Data Type Comments or Value Assigned
sysconfigures – – – – –
syscurconfigs – – – – –
sysdatabases x name x VARCHAR
(60)
The fully qualified SQL Server
database name
(database.owner) in uppercase
letters.
dbid x INT (2)
UNSIGNED
An internal ID used by the
NonStop ODBC Server.
suid x INT (2)
UNSIGNED
The 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 – – Assigned -1
status – – Assigned -1
version x INT (2) NonStop ODBC Server version
number.
crdate x DATETIME The date and time the catalog
was created or customized.
sysdevices – – – – –
syslocks – – – – –
syslogins –– –– –
x Indicates a supported table or column
– Indicates an unsupported table or column