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.

Columns
Column name Column type Column constraint Table constraints
logging_session_id UNSIGNED INT NOT NULL

Primary key.

Foreign key references sa_diagnostic_request.

request_id UNSIGNED BIGINT NOT NULL

Primary key.

Foreign key references sa_diagnostic_request.

cursor_id UNSIGNED BIGINT
hostvar_num UNSIGNED SMALLINT NOT NULL Primary key.
hostvar_type UNSIGNED TINYINT NOT NULL
hostvar_value LONG 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