Class INFORMATION.SCHEMA.CURRENTSTATEMENTS

persistent class INFORMATION.SCHEMA.CURRENTSTATEMENTS extends %Library.Persistent, %XML.Adaptor

SQL Table Name: CURRENT_STATEMENTS

Returns one row for each metadata string pushed onto the Application Metadata Stack (AMS) that belongs to the SQL application (ApplicationID="%SQL" [WHERE "%SQL"=$$$AMSApplicationIDSQL]).

The GetStackInfo method within the %SYS.AppMetadataStack.SQL class returns the data ResultSet for this class/table.

Inventory

Parameters	Properties	Methods	Queries	Indices	ForeignKeys	Triggers
1	24	1

Summary

Properties
AppMetadataStackID	CachedQuery	CallerName	ChildStatements
CurrentWorkerCount	ExecutionDuration	ExecutionStart	ExecutionStartUTC
NameSpace	Parameters	Parent	ParentType
ProcessId	QueryRunType	QueryStmtType	SQLStatementID
Server	StatementIndexHash	StatementOrder	Status
SubStatement	TPNestingLevel	UserName

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
GetSQLStatement	XMLDTD	XMLExport	XMLExportToStream
XMLExportToString	XMLNew	XMLSchema	XMLSchemaNamespace
XMLSchemaType

Parameters

• parameter READONLY = 1;

READONLY = 1 means that objects can be created, opened but not saved or deleted. Tables are projected to SQL as READONLY.

Properties

• property AppMetadataStackID as %List;

MRP1317
The first $LIST(...) element of the Application Metadata Stack's (AMS) metadata string, which is itself a $LIST(...) string that is comprised of two or more elements that can be used to uniquely identify the metadata string of the application that pushed this information onto the AMS

• property CachedQuery as %String;

Name of the Cached Query class created for this SQL Statement NOTE: For some Embedded SQL DDL Statements, this will be the name of the Class/Routine in which the Embedded SQL DDL Statement is specified and code generated

• property CallerName as %String;

Name of the Routine/Class who called this SQL Statement If this is the top-most SQL Statement, then this value will be the empty string ("")

• property ChildStatements as %List;

$LIST(...) of {StatementIndexHash} for all Children Queries

• property CurrentWorkerCount as %Integer;

Number of workers currently active on behalf of this SQL Statement

• property ExecutionDuration as %Numeric(SCALE=6) [ Required ];

Amount of time (in seconds) in which this SQL Query has been executing

• property ExecutionStart as %TimeStamp [ Required ];

Timestamp when this SQL Query started executing (in local timezone)

• property ExecutionStartUTC as %TimeStamp [ Required ];

UTC timestamp when this SQL Query started executing

• property NameSpace as %String [ SqlFieldName = Namespace,Required ];

Namespace in which this SQL Statement was built/compiled into a Cached Query and invoked

• property Parameters as %List;

First 10 SQL Statement parameters (might be truncated)

• relationship Parent as INFORMATION.SCHEMA.CURRENTSTATEMENTS [ Inverse = SubStatement,Cardinality = one ];

• property ParentType as %String;

Parent Type: Parallel, Sharded

• property ProcessId as %String [ SqlFieldName = ProcessID,Required ];

Identifies the IRIS process ($JOB) in which this SQL Statement is running

• property QueryRunType as %String [ Required ];

SQL Query Run Type of this SQL Statement: EmbeddedSQL | DynamicSQL | xDBCQuery | ...

• property QueryStmtType as %Integer [ Required ];

SQL Query Statement Type # of this SQL Statement: 1 = SELECT | 2 = INSERT | 3 = UPDATE | 4 = DELETE | ... | 72 = CANCEL QUERY

• property SQLStatementID as %Integer;

The second element of the AppMetadataStackID property, which is a unique SQL Statement Identifier that can be used to identify a SQL Statement that is stored in the SQL Statement Index (SSI)

• property Server as %String [ Required ];

Identifies the instance on which this SQL Statement is running: :

• property StatementIndexHash as %String [ Required ];

SQL StatementIndex hash of this SQL Statement, which is used as a pointer to the internal definition stored in the SQL Statement Index (SSI)

• property StatementOrder as %Integer [ Required ];

Order in which this SQL Statement is being executed, based on the ^||oddSQL.CURRENTSTATEMENTS("orderStmts") $LIST(...)

• property Status as %String [ Calculated,Required ];

SQL Query Status: Preparing, Executing (Current Default), Closed, Aborted - or more fine-grained

• relationship SubStatement as INFORMATION.SCHEMA.CURRENTSTATEMENTS [ Inverse = Parent,Cardinality = many ];

• property TPNestingLevel as %Integer [ SqlFieldName = TP_NestingLevel,Required ];

Current nesting level for Transaction Processing (TP)

• property UserName as %String [ Required ];

$USERNAME of person who created and invoked this SQL Statement

Methods

• classmethod GetSQLStatement(ns As %String = "", hash As %String = "", Output tSC="", normalize As %Boolean = 1, upper As %Boolean = 0) as %String [ SQLProc = GetSQLStatement ]

Get and return the SQL Statement Text based on the {NameSpace} & {StatementIndexHash} fields NOTE: Users with "USE" permission on the %Development resource can get all SQL Statements

Class Reference IRIS for UNIX 2024.1.2
Documentation Search