Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Reference » Tables » Diagnostic tracing tables

sa_diagnostic_deadlock table Next Page

sa_diagnostic_hostvariable table

The sa_diagnostic_hostvariable table is owned by the dbo user, and contains the values of host variables used by the specified cursor.

There are two versions of this table: sa_diagnostic_hostvariable, and sa_tmp_diagnostic_hostvariable.

Column name Column type Column constraint Table constraints
logging_session_idUNSIGNED INTNOT NULL

Primary key.

Foreign key references sa_diagnostic_request.


Primary key.

Foreign key references sa_diagnostic_request.

hostvar_numUNSIGNED SMALLINTNOT NULLPrimary key.
hostvar_valueLONG VARCHAR

logging_session_id    A number uniquely identifying the logging session during which the diagnostic information was gathered.

request_id    The ID of the request to which the host variables belong.

cursor_id    The ID of the cursor to which the host variables pertain.

hostvar_num    The ordinal position of the host variable in the SQL statement.

hostvar_type    The domain number of the host variable, typically a string, integer, or a float.

hostvar_value    A string representing the value of the host variable. Even if the host variable is an integer or a float, the value is still represented here as a string.

See also