SESSION_PARAMETERS

Provides information about user-defined parameters (UDPARAMETERS) set for the current session.

Column Name Data Type Description
SESSION_ID

VARCHAR

The unique identifier for the session.

SCHEMA_NAME

VARCHAR

The name of the schema on which the session is running.

LIB_NAME

VARCHAR

The name of the user library running the UDx, if necessary.

LIB_OID

VARCHAR

The object ID of the library containing the function, if one is running.

PARAMETER_NAME

VARCHAR

The name of the session parameter.

CURRENT_VALUE

VARCHAR

The value of the session parameter.

See Also