IRISLIB database
SQL Class Reference
Inheritance diagram for SQL:
Collaboration diagram for SQL:

Public Member Functions

_.Library.Status ClearStats ()
 Remove any SQL stats we have aggregated so far.
 
_.Library.Status SaveStats ()
 Store any SQL stats we have collected so far. More...
 
_.Library.RawString getCachedGateway (_.Library.String serverName)
 Return a cached gateway connection, null if nothing is cached.
 
_.Library.RawString getGateway (_.Library.String gatewayName, _.Library.String language)
 language is only used if the gateway is not already defined
 
_.Library.Status popState ()
 popState will restore the state of the Context.SQL singleton from the top of the contextStack and remove More...
 
_.Library.Status pushState ()
 pushState will push the current state of the Context.SQL singleton onto the contextStack. More...
 

Public Attributes

 CQLockTimeout
 Cached Query Lock Timeout. More...
 
 DisableStatCollection
 This can be set to true to disable time based collection of SQL stats. More...
 
 FTKeys
 Feature Tracker Keys for features tracked under the SQL/IntegratedML/xDBC umbrella. More...
 
 MLConfiguration
 This is the default SYS.ML.Configuration for this process. More...
 
 PredictModelOref
 PredictModelOref holds an oref for the ML Model for each PREDICT function in the statement. More...
 
 PredictTrainedModelOref
 PredictTrainedModelOref holds an oref for the ML TrainedModel for each PREDICT function in the statement. More...
 
 RTC
 RTC is an array of trigger names used for statement level recursive trigger call checking. More...
 
 ShardAIRange
 ShardAIRange is an array of extent names used for allocating auto_increment field values for Sharded=2 tables. More...
 
 ShardExecIUDArgs
 ShardExecIUDArgs is used to hold the arguments for the BigData.ShardedSQL. More...
 
 ShardIDRange
 ShardIDRange is an array of extent names used for allocating rowid values for Sharded=2 tables. More...
 
 ShardMasterExtRef
 ShardMasterExtRef is used to hold the extended reference for the constraint lock syntax to use for this namespace. More...
 
 ShardNumber
 ShardNumber is used to hold the shard number of the current namespace if this is a sharded namespace. More...
 
 Stats
   More...
 
 TSQLAnsiNulls
   More...
 
 TSQLAnsiPadding
   More...
 
 TSQLAnsiWarnings
   More...
 
 TSQLCaseInsCompare
   More...
 
 TSQLNoCount
   More...
 
 TSQLQuotedIdentifier
   More...
 
 contextStack
   More...
 
 externalGateways
   More...
 

Member Function Documentation

◆ SaveStats()

_.Library.Status SaveStats ( )

Store any SQL stats we have collected so far.

Normally done automatically at regular time intervals but can be forced by calling this method.

◆ popState()

_.Library.Status popState ( )

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.

◆ pushState()

_.Library.Status pushState ( )

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.

Member Data Documentation

◆ CQLockTimeout

CQLockTimeout

Cached Query Lock Timeout.

 

◆ DisableStatCollection

DisableStatCollection

This can be set to true to disable time based collection of SQL stats.

 

◆ FTKeys

FTKeys

Feature Tracker Keys for features tracked under the SQL/IntegratedML/xDBC umbrella.

 

◆ MLConfiguration

MLConfiguration

This is the default SYS.ML.Configuration for this process.

 

◆ PredictModelOref

PredictModelOref

PredictModelOref holds an oref for the ML Model for each PREDICT function in the statement.

 

◆ PredictTrainedModelOref

PredictTrainedModelOref

PredictTrainedModelOref holds an oref for the ML TrainedModel for each PREDICT function in the statement.

 

◆ RTC

RTC

RTC is an array of trigger names used for statement level recursive trigger call checking.


RTC = recursive trigger check  

◆ ShardAIRange

ShardAIRange

ShardAIRange is an array of extent names used for allocating auto_increment field values for Sharded=2 tables.

data is $lb(beginrange,endrange,offset)

 

◆ ShardExecIUDArgs

ShardExecIUDArgs

ShardExecIUDArgs is used to hold the arguments for the BigData.ShardedSQL.

ExecIUD method when the SQL Statement has more than 379 parameters.

 

◆ ShardIDRange

ShardIDRange

ShardIDRange is an array of extent names used for allocating rowid values for Sharded=2 tables.

data is $lb(beginrange,endrange,offset)

 

◆ ShardMasterExtRef

ShardMasterExtRef

ShardMasterExtRef is used to hold the extended reference for the constraint lock syntax to use for this namespace.

Since subscript is the namespace name.  

◆ ShardNumber

ShardNumber

ShardNumber is used to hold the shard number of the current namespace if this is a sharded namespace.

Subscript is the namespace name.  

◆ Stats

Stats

 

 

◆ TSQLAnsiNulls

TSQLAnsiNulls

 

 

◆ TSQLAnsiPadding

TSQLAnsiPadding

 

 

◆ TSQLAnsiWarnings

TSQLAnsiWarnings

 

 

◆ TSQLCaseInsCompare

TSQLCaseInsCompare

 

 

◆ TSQLNoCount

TSQLNoCount

 

 

◆ TSQLQuotedIdentifier

TSQLQuotedIdentifier

 

 

◆ contextStack

contextStack

 

 

◆ externalGateways

externalGateways