|
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_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.