ODBC Server Reference Manual

Summary of Support for SQL Server Features
HP NonStop ODBC Server Reference Manual—429151-002
B-23
System Tables in All Databases
cache – – Assigned -1
sysprocedure
s
–– –– –
sysprotects x id x INT (4) An object ID used internally by
the NonStop ODBC Server.
uid x INT (2)
UNSIGNED
A user ID used internally by the
NonStop ODBC Server.
action x INT (2) An integer corresponding to a
Transact-SQL statement, for
example:
193 SELECT
195 INSERT
196 DELETE
197 UPDATE
protecttype x INT (2) An integer, 205, corresponding
to GRANT permission. REVOKE
(206) is not supported. When
using the NonStop ODBC
Server, all users are granted
permission for all statements.
columns – – Assigned “ ” (blank)
syssegments – – – – –
systypes x uid – – Assigned 1
usertype x INT (2) An SQL Server user-defined
data type code.
variable – – Assigned -1
allownulls – – Assigned -1
type x INT (2) The SQL Server data type code.
length – – Assigned -1
tdefault – – Assigned 0
Table B-7. NonStop ODBC Server Support of System Tables in All
Databases (page 4 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