ODBC Server Reference Manual

Summary of Support for SQL Server Features
HP NonStop ODBC Server Reference Manual—429151-002
B-26
Variables
Variables
The NonStop ODBC Server supports local and global variables.
There are some restrictions for using local variables:
•
A variable cannot be null when it is referenced.
•
Variable expressions are not allowed in date functions.
•
You cannot mix nonaggregate and aggregate assignments to variables.
•
Variable expressions are not allowed in some constructs.
sysmessages x error x INT (4) The SQL Server error code that
corresponds to this message. If
there is no corresponding SQL
Server error code, the code is
18001.
severity x INT (2) The SQL Server error severity
level:
10 Warning
11-16 User-generated
17-18 Nonfatal error
19+ Fatal error
dlevel x INT (2) The SQL Server error detail
level. Detail level is not
supported and is always -1.
description x VARCHAR
(255)
The error text.; it can be SQL
Server text, NonStop SQL/MP
text, or NonStop ODBC Server
text.
sysprocesses – – – – –
sysusages – – – – –
Table B-8. NonStop ODBC Server Support of System Tables in the Master
Database Only (page 2 of 2)
Columns
Table Name NonStop ODBC Server Support Column Name NonStop ODBC Server Support Data Type Comments or Value Assigned
x Indicates a supported table or column
– Indicates an unsupported table or column