SESSION_PARAMETERS

Provides information about current parameters that are configurable at the session level. To view parameters configurable at all levels, see the CONFIGURATION_PARAMETERS system table.

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

Configuration Parameters