InterSystems IRIS Data Platform 2020.4 > Class Reference > ENSLIB namespace > %SYSTEM.Context.SQL

%SYSTEM.Context.SQL

donotuse class %SYSTEM.Context.SQL extends %Library.SystemBase

Property Inventory

Method Inventory

Properties

property CQLockTimeout as %Integer;
Cached Query Lock Timeout
property DisableStatCollection as %Boolean [ InitialExpression = 0 ];
This can be set to true to disable time based collection of SQL stats
Property methods: DisableStatCollectionSet()
property RTC as %RawString [ MultiDimensional ];
RTC is an array of trigger names used for statement level recursive trigger call checking.
RTC = recursive trigger check
property ShardAIRange as %RawString [ MultiDimensional ];
ShardAIRange is an array of extent names used for allocating auto_increment field values for Sharded=2 tables. data is $lb(beginrange,endrange,offset)
property ShardExecIUDArgs as %String [ MultiDimensional ];
ShardExecIUDArgs is used to hold the arguments for the %BigData.SHardedSQL.%ExecIUD method when the SQL Statement has more than 379 parameters.
property ShardIDRange as %RawString [ MultiDimensional ];
ShardIDRange is an array of extent names used for allocating rowid values for Sharded=2 tables. data is $lb(beginrange,endrange,offset)
property ShardMasterExtRef as %RawString [ MultiDimensional ];
ShardMasterExtRef is used to hold the extended reference for the constraint lock syntax to use for this namespace. Since subscript is the namespace name.
property Stats as %String [ MultiDimensional ];
property TSQLAnsiNulls as %Integer;
property TSQLAnsiPadding as %Integer;
property TSQLAnsiWarnings as %Integer;
property TSQLCaseInsCompare as %Integer;
property TSQLNoCount as %Integer;
property TSQLQuotedIdentifier as %Integer;
property contextStack as %String) [ MultiDimensional ];

Methods

method ClearStats() as %Status [ Language = objectscript ]
Remove any SQL stats we have aggregated so far
method DisableStatCollectionSet(val As %Boolean) as %Status [ Language = objectscript ]
method SaveStats() as %Status [ Language = objectscript ]
Store any SQL stats we have collected so far. Normally done automatically at regular time intervals but can be forced by calling this method.
method popState() as %Status [ Language = objectscript ]
popState will restore the state of the Context.SQL singleton from the top of the contextStack and remove the top stack element. This method is not normally invoked directly. It is normally called by a utility class method to pop a context.
method pushState() as %Status [ Language = objectscript ]
pushState will push the current state of the Context.SQL singleton onto the contextStack. This method is not normally invoked directly. It is normally called by a utility class method to push a context.
Feedback