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	Description
logging_session_id	UNSIGNED INT	A number uniquely identifying the logging session during which the diagnostic information was gathered.
request_id	UNSIGNED BIGINT	The ID of the request to which the host variables belong.
cursor_id	UNSIGNED BIGINT	The ID of the cursor to which the host variables pertain.
hostvar_num	UNSIGNED SMALLINT	The ordinal position of the host variable in the SQL statement.
hostvar_type	UNSIGNED TINYINT	The domain number of the host variable, typically a string, integer, or a float.
hostvar_value	LONG NVARCHAR	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.