E.3 MON$CONTEXT_VARIABLES

MON$CONTEXT_VARIABLES displays information about custom context variables.

Column NameData TypeDescription

MON$ATTACHMENT_ID

BIGINT

Connection identifier. It contains a valid value only for a connection-level context variable. For transaction-level variables it is NULL.

MON$TRANSACTION_ID

BIGINT

Transaction identifier. It contains a valid value only for transaction-level context variables. For connection-level variables it is NULL.

MON$VARIABLE_NAME

VARCHAR(80)

Context variable name

MON$VARIABLE_VALUE

VARCHAR(32765)

Context variable value

Retrieving all session context variables for the current connection

  1. SELECT
  2.   VAR.MON$VARIABLE_NAME,
  3.   VAR.MON$VARIABLE_VALUE
  4. FROM MON$CONTEXT_VARIABLES VAR
  5. WHERE VAR.MON$ATTACHMENT_ID = CURRENT_CONNECTION