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_hostvariable table Next Page

sa_diagnostic_internalvariable table


The sa_diagnostic_internalvariable table is owned by the dbo user, and contains the values of internal (local) variables used by a given statement. This table is primarily used by the Index Consultant, and the traced_plan function.

There are two versions of this table: sa_diagnostic_internalvariable, and sa_tmp_diagnostic_internalvariable.

Columns
Column name Column type Column constraint Table constraints
logging_session_idUNSIGNED INTNOT NULL
request_idUNSIGNED BIGINT
rowvariable_idUNSIGNED INT
variable_domainUNSIGNED SMALLINT
variable_nameCHAR(128)
variable_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 that contains the internal variable.

rowvariable_id    The column number in the row variable of this value.

variable_domain    The data type of the internal variable.

variable_name    The name of the internal variable.

variable_value    A string representing the value of the internal variable.

See also