Skip to main content

%SYSTEM.Context.DBMSSession

Class %SYSTEM.Context.DBMSSession Extends %SystemBase

Properties​

context​

Property context As %RawString [ MultiDimensional ];

Methods​

getContext​

Method getContext(context, parameterName) As %String(MAXLEN="") [ CodeMode = expression ]

setContext​

Method setContext(context, parameterName, value) As %String(MAXLEN=4096)

"SYS_CONTEXT"​

ClassMethod "SYS_CONTEXT"(context As %String(MAXLEN=220), parameterName As %String(MAXLEN=220)) As %String(MAXLEN=4096) [ CodeMode = expression, SqlName = SYS_CONTEXT, SqlProc ]

"CLEAR_ALL_CONTEXT"​

ClassMethod "CLEAR_ALL_CONTEXT"() [ SqlName = CLEAR_ALL_CONTEXT, SqlProc ]

Clears all context information

"CLEAR_CONTEXT"​

ClassMethod "CLEAR_CONTEXT"() [ SqlName = CLEAR_CONTEXT, SqlProc ]

Clears the context

"CLEAR_IDENTIFIER"​

ClassMethod "CLEAR_IDENTIFIER"() [ SqlName = CLEAR_IDENTIFIER, SqlProc ]

Clears the identifier

ClassMethod "CLOSE_DATABASE_LINK"() [ SqlName = CLOSE_DATABASE_LINK, SqlProc ]

Closes database link

"FREE_UNUSED_USER_MEMORY"​

ClassMethod "FREE_UNUSED_USER_MEMORY"() [ SqlName = FREE_UNUSED_USER_MEMORY, SqlProc ]

Lets you reclaim unused memory after performing operations requiring large amounts of memory

"IS_ROLE_ENABLED"​

ClassMethod "IS_ROLE_ENABLED"() [ SqlName = IS_ROLE_ENABLED, SqlProc ]

Determines if the named role is enabled for the session.

"IS_SESSION_ALIVE"​

ClassMethod "IS_SESSION_ALIVE"() [ SqlName = IS_SESSION_ALIVE, SqlProc ]

Determines if the specified session is active

"LIST_CONTEXT"​

ClassMethod "LIST_CONTEXT"() [ SqlName = LIST_CONTEXT, SqlProc ]

Returns a list of active namespace and context for the current session

"SESSION_TRACE_DISABLE"​

ClassMethod "SESSION_TRACE_DISABLE"() [ SqlName = SESSION_TRACE_DISABLE, SqlProc ]

Resets the session-level SQL trace for the session from which it was called.

"SESSION_TRACE_ENABLE"​

ClassMethod "SESSION_TRACE_ENABLE"() [ SqlName = SESSION_TRACE_ENABLE, SqlProc ]

Enables session-level SQL trace for the invoking session

"RESET_PACKAGE"​

ClassMethod "RESET_PACKAGE"() [ SqlName = RESET_PACKAGE, SqlProc ]

De-instantiates all packages in the session

"SET_CONTEXT"​

ClassMethod "SET_CONTEXT"(namespace As %String(MAXLEN=30), attribute As %String(MAXLEN=30), value As %String(MAXLEN=4096)) As %String(MAXLEN=4096) [ CodeMode = expression, SqlName = SET_CONTEXT, SqlProc ]

Sets or resets the value of a context attribute

"SET_IDENTIFIER"​

ClassMethod "SET_IDENTIFIER"() [ SqlName = SET_IDENTIFIER, SqlProc ]

Sets the identifier

"SET_NLS"​

ClassMethod "SET_NLS"() [ SqlName = SET_NLS, SqlProc ]

Sets Globalization Support (NLS)

"SET_ROLE"​

ClassMethod "SET_ROLE"() [ SqlName = SET_ROLE, SqlProc ]

Sets role

"SET_SQL_TRACE"​

ClassMethod "SET_SQL_TRACE"() [ SqlName = SET_SQL_TRACE, SqlProc ]

Turns tracing on or off

"SWITCH_CURRENT_CONSUMER_GROUP"​

ClassMethod "SWITCH_CURRENT_CONSUMER_GROUP"() [ SqlName = SWITCH_CURRENT_CONSUMER_GROUP, SqlProc ]

Facilitates changing the current resource consumer group of a user's current session

"UNIQUE_SESSION_ID"​

ClassMethod "UNIQUE_SESSION_ID"() [ SqlName = UNIQUE_SESSION_ID, SqlProc ]

Returns an identifier that is unique for all sessions currently connected to this database