ODBC Server Reference Manual

Transact-SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
4-27
Variables
If you use an unsupported global variable, the NonStop ODBC Server returns the value
indicated in Table 4-9.
Global Variables in a Batch
In Transact-SQL, global variables must be used within a batch. In the NonStop ODBC
Server, global variables do not need to be in a batch.
Declaring Values for Global Variables
In Transact-SQL, you can declare values for global variables (for the current batch
only). In the NonStop ODBC Server, you cannot declare values for global variables.
Table 4-9. Global Variables
Global Variable
NonStop ODBC
Server Support Comments or value assigned
@@connections x The value is always 1.
@@cpu_busy – -1
@@error x No differences.
@@idle – -1
@@io_busy – -1
@@max_connections x Depends on the system resources.
@@next_level – -1
@@pack_received – -1
@@pack_sent – -1
@@packet_errors – -1
@@procid – -1
@@rowcount – 0
@@textsize x The default is 512. (In Transact-SQL, it is
4058.)
@@timeticks – -1
@@total_errors – -1
@@total_read – -1
@@total_write – -1
@@trancount x The value will be either 0 or 1 because nested
transactions are not supported. The default is
0.
@@version – NonStop ODBC Server T8666D20
x Indicates a supported global variable
– Indicates an unsupported global variable