Chapter 3: Querying and Setting Operating Values

Syntax

Global variables are preceded by two “at” (@@) symbols and are not case sensitive.

To query a global variable, issue a SQL statement in the following form:

select @@variable_name

where variable_name is the name of the relevant global variable.

The access service returns the configuration property value or the processing information for the current connection.

For example, the SQL statement select @@Allocate returns the Allocate configuration property value of either connect or request.