INFORMATION.SCHEMA.CURRENTSTATEMENTS
persistent class INFORMATION.SCHEMA.CURRENTSTATEMENTS extends %Library.Persistent, %XML.Adaptor
SQL Table Name: INFORMATION_SCHEMA.CURRENT_STATEMENTS
Property Inventory
- CachedQuery
- CurrentWorkerCount
- ExecutionDuration
- NameSpace
- NestingLevel
- Parameters
- Parent
- ParentType
- ProcessId
- Querytype
- Server
- StatementIndexHash
- Status
- SubStatement
- SubStatements
- UserName
Parameters
parameter READONLY = 1;
Inherited description: READONLY = 1 means that objects can be created, opened but not saved or deleted.
Tables are projected to SQL as READONLY.
Properties
property CachedQuery as %String;
Name of the cached query class chosen for running this statement
Property methods: CachedQueryDisplayToLogical(), CachedQueryGet(), CachedQueryIsValid(), CachedQueryLogicalToDisplay(), CachedQueryLogicalToOdbc(), CachedQueryNormalize(), CachedQuerySet()
property CurrentWorkerCount as %Integer;
Number of workers currently active on behalf of this statement
Property methods: CurrentWorkerCountDisplayToLogical(), CurrentWorkerCountGet(), CurrentWorkerCountIsValid(), CurrentWorkerCountLogicalToDisplay(), CurrentWorkerCountNormalize(), CurrentWorkerCountSet(), CurrentWorkerCountXSDToLogical()
property ExecutionDuration as %Numeric (SCALE = 6) [ Required ];
How long has it been executing
Property methods: ExecutionDurationDisplayToLogical(), ExecutionDurationGet(), ExecutionDurationIsValid(), ExecutionDurationLogicalToDisplay(), ExecutionDurationNormalize(), ExecutionDurationSet(), ExecutionDurationXSDToLogical()
property NameSpace as %String [ Required ];
Namespace
Property methods: NameSpaceDisplayToLogical(), NameSpaceGet(), NameSpaceIsValid(), NameSpaceLogicalToDisplay(), NameSpaceLogicalToOdbc(), NameSpaceNormalize(), NameSpaceSet()
property NestingLevel as %Integer [ Required ];
Current nesting level for transaction processing
Property methods: NestingLevelDisplayToLogical(), NestingLevelGet(), NestingLevelIsValid(), NestingLevelLogicalToDisplay(), NestingLevelNormalize(), NestingLevelSet(), NestingLevelXSDToLogical()
property Parameters as %List;
first 10 query parameters (might be truncated)
Property methods: ParametersGet(), ParametersIsValid(), ParametersLogicalToOdbc(), ParametersLogicalToXSD(), ParametersOdbcToLogical(), ParametersSet(), ParametersXSDToLogical()
relationship Parent as INFORMATION.SCHEMA.CURRENTSTATEMENTS [ Inverse = SubStatement , Cardinality = one ];
Property methods: ParentCheck(), ParentDelete(), ParentGet(), ParentGetObject(), ParentGetObjectId(), ParentGetSwizzled(), ParentIsValid(), ParentNewObject(), ParentOnDelete(), ParentRClose(), ParentRExec(), ParentRFetch(), ParentRelate(), ParentSQLCompute(), ParentSQLFKeyExists(), ParentSQLFKeyRefAction(), ParentSet(), ParentSetObject(), ParentSetObjectId(), ParentTypeDisplayToLogical(), ParentTypeGet(), ParentTypeIsValid(), ParentTypeLogicalToDisplay(), ParentTypeLogicalToOdbc(), ParentTypeNormalize(), ParentTypeSet(), ParentUnRelate(), ParentUnSwizzle()
property ParentType as %String;
Parent Type: Parallel, Sharded
Property methods: ParentTypeDisplayToLogical(), ParentTypeGet(), ParentTypeIsValid(), ParentTypeLogicalToDisplay(), ParentTypeLogicalToOdbc(), ParentTypeNormalize(), ParentTypeSet()
property ProcessId as %String [ Required ];
IRIS process in which the statement is running
Property methods: ProcessIdDisplayToLogical(), ProcessIdGet(), ProcessIdIsValid(), ProcessIdLogicalToDisplay(), ProcessIdLogicalToOdbc(), ProcessIdNormalize(), ProcessIdSet()
property Querytype as %String [ Required ];
Query Type: Dynamic SQL/embedded SQL/xdbc Query
Property methods: QuerytypeDisplayToLogical(), QuerytypeGet(), QuerytypeIsValid(), QuerytypeLogicalToDisplay(), QuerytypeLogicalToOdbc(), QuerytypeNormalize(), QuerytypeSet()
property Server as %String [ Required ];
Identifies the instance this statement is running on (hostname:supersever port)
Property methods: ServerDisplayToLogical(), ServerGet(), ServerIsValid(), ServerLogicalToDisplay(), ServerLogicalToOdbc(), ServerNormalize(), ServerSet()
property StatementIndexHash as %String [ Required ];
Statement index hash of this query
Property methods: StatementIndexHashDisplayToLogical(), StatementIndexHashGet(), StatementIndexHashIsValid(), StatementIndexHashLogicalToDisplay(), StatementIndexHashLogicalToOdbc(), StatementIndexHashNormalize(), StatementIndexHashSet()
property Status as %String [ Calculated , Required ];
Preparing, Executing (Current Default), Closed, Aborted - or more fine-grained
Property methods: StatusCompute(), StatusDisplayToLogical(), StatusGet(), StatusIsValid(), StatusLogicalToDisplay(), StatusLogicalToOdbc(), StatusNormalize(), StatusSQLCompute()
relationship SubStatement as array of INFORMATION.SCHEMA.CURRENTSTATEMENTS [ InitialExpression = $listbuild("INFORMATION.SCHEMA.CURRENTSTATEMENTS","Parent",+$this,"many",1,1) , Transient , Inverse = Parent , Cardinality = many ];
Property methods: SubStatementGet(), SubStatementGetObject(), SubStatementGetObjectId(), SubStatementGetSwizzled(), SubStatementIsEmpty(), SubStatementIsValid(), SubStatementNewObject(), SubStatementRClose(), SubStatementRExec(), SubStatementRFetch(), SubStatementRelate(), SubStatementSQLCompute(), SubStatementSet(), SubStatementUnRelate(), SubStatementsGet(), SubStatementsIsValid(), SubStatementsLogicalToOdbc(), SubStatementsLogicalToXSD(), SubStatementsOdbcToLogical(), SubStatementsSet(), SubStatementsXSDToLogical()
property SubStatements as %List;
List of direct subqueries
Property methods: SubStatementsGet(), SubStatementsIsValid(), SubStatementsLogicalToOdbc(), SubStatementsLogicalToXSD(), SubStatementsOdbcToLogical(), SubStatementsSet(), SubStatementsXSDToLogical()
property UserName as %String [ Required ];
User name
Property methods: UserNameDisplayToLogical(), UserNameGet(), UserNameIsValid(), UserNameLogicalToDisplay(), UserNameLogicalToOdbc(), UserNameNormalize(), UserNameSet()
Inherited Members
Inherited Methods
- %AddToSaveSet()
- %AddToSyncSet()
- %BuildDeferredIndices()
- %BuildIndicesAsync()
- %BuildIndicesAsyncResponse()
- %CheckConstraints()
- %CheckConstraintsForExtent()
- %ClassIsLatestVersion()
- %ClassName()
- %ComposeOid()
- %ConstructClone()
- %Delete()
- %DeleteExtent()
- %DeleteId()
- %DispatchClassMethod()
- %DispatchGetModified()
- %DispatchGetProperty()
- %DispatchMethod()
- %DispatchSetModified()
- %DispatchSetMultidimProperty()
- %DispatchSetProperty()
- %Exists()
- %ExistsId()
- %Extends()
- %GUID()
- %GUIDSet()
- %GetLock()
- %GetParameter()
- %GetSwizzleObject()
- %Id()
- %IsA()
- %IsModified()
- %IsNull()
- %KillExtent()
- %LockExtent()
- %LockId()
- %New()
- %NormalizeObject()
- %ObjectIsNull()
- %ObjectModified()
- %Oid()
- %OnBeforeAddToSync()
- %OnDeleteFinally()
- %OnDetermineClass()
- %OnOpenFinally()
- %OnSaveFinally()
- %Open()
- %OpenId()
- %OriginalNamespace()
- %PackageName()
- %PurgeIndices()
- %Reload()
- %RemoveFromSaveSet()
- %ResolveConcurrencyConflict()
- %RollBack()
- %Save()
- %SaveDirect()
- %SerializeObject()
- %SetModified()
- %SortBegin()
- %SortEnd()
- %SyncObjectIn()
- %SyncTransport()
- %UnlockExtent()
- %UnlockId()
- %ValidateIndices()
- %ValidateObject()
- %ValidateTable()
- XMLDTD()
- XMLExport()
- XMLExportToStream()
- XMLExportToString()
- XMLNew()
- XMLSchema()
- XMLSchemaNamespace()
- XMLSchemaType()
Storage
Gray indicates storage defined by superclasses.
Storage Model: SQLStorage
Maps: 1
Map number 1 is named Master
thismap.Global: %StackInfo
%StackInfo({Server},{ProcessId},{StatementIndexHash})
|
= |
|