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]). More...

Inheritance diagram for CURRENTSTATEMENTS:

[legend]

Collaboration diagram for CURRENTSTATEMENTS:

[legend]

Static Public Member Functions
_.Library.String	GetSQLStatement (_.Library.String ns, _.Library.String hash, tSC, _.Library.Boolean normalize, _.Library.Boolean upper)
	Get and return the SQL Statement Text based on the {NameSpace} & {StatementIndexHash} fields. More...

Static Public Member Functions inherited from Persistent
_.Library.Status	DeleteData (_.Library.String id, _.Library.Integer concurrency)
	This method is normally generated by the storage class for persistent classes using. More...

_.Library.Status	KillExtentData (_.Library.Boolean killstreams)
	KillExtentData() - kills extent data in storage. More...

_.Library.Status	OnAfterBuildIndices (_.Library.String indexlist)
	This callback method is invoked by the <METHOD>BuildIndices</METHOD> method after all work is completed. More...

_.Library.Status	OnAfterDelete (_.Library.ObjectIdentity oid)
	This callback method is invoked by the <METHOD>Delete</METHOD> method to. More...

_.Library.Status	OnAfterPurgeIndices (_.Library.String indexlist)
	This callback method is invoked by the <METHOD>PurgeIndices</METHOD> method after all work is completed. More...

_.Library.Status	OnBeforeBuildIndices (_.Library.String indexlist)

_.Library.Status	OnBeforePurgeIndices (_.Library.String indexlist)

_.Library.Status	OnDelete (_.Library.ObjectIdentity oid)
	This callback method is invoked by the <METHOD>Delete</METHOD> method to. More...

Static Public Member Functions inherited from Adaptor
_.Library.Status	XMLDTD (_.Library.String top, _.Library.String format, _.Library.Boolean input, dtdlist)
	Write the DTD to the current device for this XML enabled class serialized as. More...

_.Library.RegisteredObject	XMLNew (_.XML.Document document, _.Library.Integer node, _.Library.RegisteredObject containerOref)
	Get an instance of an XML enabled class. More...

_.Library.Status	XMLSchema (_.Library.String top, _.Library.String format, _.Library.String namespacePrefix, _.Library.Boolean input, _.Library.Boolean refOnly, schema)
	Write an XML Schema fragment to the current device which describes an XML enabled class and dependent classes. More...

_.Library.String	XMLSchemaNamespace ()
	Get the namespace to which this class belongs for use in schema generation. More...

_.Library.Status	XMLSchemaType (_.XML.Schema schemaInstance, _.XML.Node node, _.Library.String top, _.Library.Boolean encoded, _.Library.Boolean summary, _.Library.Boolean input, _.Library.Boolean refOnly)
	Add a complexType to the schema that is respresented by an <class>XML.Schema</class> instance. More...

Public Attributes
	AppMetadataStackID
	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 . More...

	CachedQuery
	Name of the Cached Query class created for this SQL Statement. More...

	CallerName
	Name of the Routine/Class who called this SQL Statement. More...

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

	CurrentWorkerCount
	Number of workers currently active on behalf of this SQL Statement. More...

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

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

	ExecutionStartUTC
	UTC timestamp when this SQL Query started executing. More...

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

	Parameters
	First 10 SQL Statement parameters (might be truncated) More...

	Parent
	More...

	ParentType
	Parent Type: Parallel, Sharded. More...

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

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

	QueryStmtType
	SQL Query Statement Type # of this SQL Statement: 1 = SELECT \| 2 = INSERT \| 3 = UPDATE \| 4 = DELETE \| ... More...

	SQLStatementID
	The second element of the <property>AppMetadataStackID</property> property, which is a. More...

	Server
	Identifies the instance on which this SQL Statement is running: <hostname>:<supersever port> More...

	StatementIndexHash
	SQL StatementIndex hash of this SQL Statement, which is used as a pointer to. More...

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

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

	SubStatement
	More...

	TPNestingLevel
	Current nesting level for Transaction Processing (TP) More...

	UserName
	$USERNAME of person who created and invoked this SQL Statement More...

Private Attributes
	__ApplicationID
	The first element of the <property>AppMetadataStackID</property> property, which identifies the application that pushed this information onto the Application Metadata Stack (AMS) . More...

Additional Inherited Members
Public Member Functions inherited from Persistent
_.Library.Status	AcquireLock (_.Library.String locktype)
	Acquires a lock for the current instance. More...

_.Library.Status	LoadData (_.Library.String id)
	LoadData() - loads an object from storage. More...

_.Library.Status	OnAfterSave (_.Library.Boolean insert)
	This callback method is invoked by the <METHOD>Save</METHOD> method to. More...

_.Library.Status	OnBeforeSave (_.Library.Boolean insert)
	This callback method is invoked by the <METHOD>Save</METHOD> method to. More...

_.Library.Status	OnOpen ()
	This callback method is invoked by the <METHOD>Open</METHOD> method to. More...

_.Library.Status	OnReload ()
	This callback method is invoked by the <METHOD>Reload</METHOD> method to. More...

_.Library.Status	OnRollBack ()
	This callback method is invoked by the <METHOD>Save</METHOD> method to. More...

_.Library.Status	ReleaseLock (_.Library.String locktype)
	Releases a lock for the current instance. More...

_.Library.Status	SaveData (_.Library.String id)
	SaveData() - saves an object to disk, checks uniqueness and referential More...

Public Member Functions inherited from SwizzleObject
_.Library.Status	OnJournalObject (_.Library.Integer tranid, _.Library.Integer jrnid, _.Library.String filter)
	This callback method is invoked by the <METHOD>JournalObject</METHOD> method to. More...

Public Member Functions inherited from RegisteredObject
_.Library.Status	OnAddToSaveSet (_.Library.Integer depth, _.Library.Integer insert, _.Library.Integer callcount)
	This callback method is invoked when the current object is added to the SaveSet,. More...

_.Library.Status	OnClose ()
	This callback method is invoked by the <METHOD>Close</METHOD> method to. More...

_.Library.Status	OnConstructClone (_.Library.RegisteredObject object, _.Library.Boolean deep, _.Library.String cloned)
	This callback method is invoked by the <METHOD>ConstructClone</METHOD> method to. More...

_.Library.Status	OnNew ()
	This callback method is invoked by the <METHOD>New</METHOD> method to. More...

_.Library.Status	OnValidateObject ()
	This callback method is invoked by the <METHOD>ValidateObject</METHOD> method to. More...

Public Member Functions inherited from Adaptor
_.Library.Status	XMLExport (_.Library.String top, _.Library.String format, _.XML.Namespaces namespaces, attrs, _.Library.String createId, _.Library.String typeAttr, oreflist, idlist, _.Library.String initialIndent, _.Library.Boolean local, _.Net.MIMEPart mimeAttachments)
	Serialize an XML enabled class as an XML document and write. More...

_.Library.Status	XMLExportToStream (_.Stream.Object export, _.Library.String top, _.Library.String format, _.XML.Namespaces namespaces, attrs, _.Library.String createId, _.Library.String typeAttr, oreflist, idlist, _.Library.String initialIndent)
	Serialize an XML enabled class as an XML document and appends it to a stream. More...

_.Library.Status	XMLExportToString (_.Library.String export, _.Library.String top, _.Library.String format, _.XML.Namespaces namespaces, attrs, _.Library.String createId, _.Library.String typeAttr, oreflist, idlist, _.Library.String initialIndent)
	Serialize an XML enabled class as an XML document and write it to a string. More...

Static Public Attributes inherited from Persistent
	XCOMPACTANCESTRY
	XCOMPACTANCESTRY can be set to a string to replace the value of the %CLASSNAME property (x__classname field) More...

	DATALOCATIONGLOBAL = None
	Global name containing master map data for this class. More...

	DEFAULTGLOBAL = None

	DSCONDITION = None
	DSCONDITION is the expression that will be evaluated before deciding whether certain actions must be taken. More...

	DSINTERVAL = None
	DSINTERVAL is the number of seconds between one DSTIME value and the next. More...

	DSTIME = None
	If the DSTIME parameter is set to AUTO then the most recent filing operation in the current DSTIME value. More...

	EXTENTQUERYSPEC = None
	The EXTENTQUERYSPEC parameter defines the properties to be retrieved in. More...

	EXTENTSIZE = None
	The EXTENTSIZE parameter is used to inform the SQL Query Optimizer More...

	GUIDENABLED = None
	If this parameter is set to 1 then a GUID will be assigned (to the GUID property) to each new object. More...

	IDENTIFIEDBY = None
	The IDENTIFIEDBY parameter can optionally be set to the name. More...

	MANAGEDEXTENT = None
	The MANAGEDEXTENT parameter can be set to 0 (zero) to cause the Extent Manager. More...

	READONLY = None
	READONLY = 1 means that objects can be created, opened but not saved or deleted. More...

	ROWLEVELSECURITY = None
	ROWLEVELSECURITY = 1 \| <property> means that row level security is active and the list More...

	SQLPREVENTFULLSCAN = None
	SQLPREVENTFULLSCAN = 1 means an attempt to prepare a query that will result in a full scan More...

	STORAGEDEFAULT = None
	STORAGEDEFAULT defines the default storage allocation to use for properties in this class. More...

	USEEXTENTSET = None

	VERSIONCLIENTNAME = None
	VERSIONCLIENTNAME can be set to a valid CLIENTNAME (see property CLIENTNAME) value. More...

	VERSIONPROPERTY = None
	VERSIONPROPERTY = <property> means that the <property> in memory will be compared to. More...

Static Public Attributes inherited from SwizzleObject
	DEFAULTCONCURRENCY = None
	DEFAULTCONCURRENCY is the default value for the concurrency formal argument. More...

	JOURNALSTREAM = None
	If OBJJOURNAL is true then the value of the JOURNALSTREAM parameter defines whether or not. More...

	OBJJOURNAL = None
	if OBJJOURNAL is TRUE then inserts, updates and deletes will be logged in ^OBJ.JournalT More...

Static Public Attributes inherited from RegisteredObject
	CAPTION = None
	Optional name used by the Form Wizard for a class when generating forms. More...

	JAVATYPE = None
	The Java type to be used when exported.

	PROPERTYVALIDATION = None
	This parameter controls the default validation behavior for the object. More...

Static Public Attributes inherited from Adaptor
	ATTRIBUTEQUALIFIED = None
	ATTRIBUTEQUALIFIED controls the format of exported XML by controlling whether attributes. More...

	ELEMENTQUALIFIED = None
	ELEMENTQUALIFIED controls the format of exported XML. More...

	NAMESPACE = None
	NAMESPACE specifies the XML namespace to be used when projecting the. More...

	SUPPRESSTYPEPREFIX = None
	SUPPRESSTYPEPREFIX allows the type name that refers to this class. More...

	XMLDEFAULTREFERENCE = None
	XMLDEFAULTREFERENCE specifies the default value of the XMLREFERENCE property parameter. More...

	XMLENABLED = None
	If this parameter is true then XML-enabling methods. More...

	XMLFORMAT = None
	The XMLFORMAT parameter controls the generation of the XMLExport and XMLImport. More...

	XMLIGNOREINVALIDATTRIBUTE = None
	The XMLIGNOREINVALIDATTRIBUTE parameter allows the programmer to control handling of unexpected. More...

	XMLIGNOREINVALIDTAG = None
	The XMLIGNOREINVALIDTAG parameter allows the programmer to control handling of unexpected. More...

	XMLIGNORENULL = None
	XMLIGNORENULL allows the programmer to override the default XML handling. More...

	XMLINCLUDEINGROUP = None
	XMLINCLUDEINGROUP allows the programmer to control whether a class is included. More...

	XMLINHERITANCE = None
	If the XMLINHERITANCE parameter is set to "LEFT", then in the case of multiple. More...

	XMLNAME = None
	This parameter provides the default XMLNAME for the class. More...

	XMLNIL = None
	The XMLNIL class parameter controls the use of xsi:nil by XMLExport. More...

	XMLNILNOOBJECT = None
	The XMLNILNOOBJECT parameter allows creation of an object to be skipped for elements. More...

	XMLPREFIX = None
	The XMLPREFIX parameter controls the prefix to be used for the XML namespace that. More...

	XMLSEQUENCE = None
	If the XMLSEQUENCE = 1, then the order of the XML elements must match the. More...

	XMLSUMMARY = None
	The summary fields to be used when an object is referenced are specified. More...

	XMLTYPE = None
	This parameter provides the default XMLTYPE for the class. More...

	XMLUNSWIZZLE = None
	If the XMLUNSWIZZLE parameter is set to 1, then single object. More...

	XMLUSEEMPTYELEMENT = None
	If the XMLUSEEMPTYELEMENT parameter is set to 1, then the empty element shorthand (<tag>) More...

Detailed Description

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 <method>GetStackInfo</method> method within the <class>SYS.AppMetadataStack.SQL</class> class returns the data ResultSet for this class/table.

Member Function Documentation

◆ GetSQLStatement()

_.Library.String GetSQLStatement	(	_.Library.String	ns,
		_.Library.String	hash,
			tSC,
		_.Library.Boolean	normalize,
		_.Library.Boolean	upper
	)

static

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

Member Data Documentation

◆ AppMetadataStackID

AppMetadataStackID

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 .

MRP1317

◆ __ApplicationID

__ApplicationID

private

The first element of the <property>AppMetadataStackID</property> property, which identifies the application that pushed this information onto the Application Metadata Stack (AMS) .

MRP1310 [Major Refactoring]

◆ CachedQuery

CachedQuery

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

◆ CallerName

CallerName

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 ("")

◆ ChildStatements

ChildStatements

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

◆ CurrentWorkerCount

CurrentWorkerCount

Number of workers currently active on behalf of this SQL Statement.

◆ ExecutionDuration

ExecutionDuration

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

◆ ExecutionStart

ExecutionStart

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

◆ ExecutionStartUTC

ExecutionStartUTC

UTC timestamp when this SQL Query started executing.

◆ NameSpace

NameSpace

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

◆ Parameters

Parameters

First 10 SQL Statement parameters (might be truncated)

◆ Parent

Parent

◆ ParentType

ParentType

Parent Type: Parallel, Sharded.

◆ ProcessId

ProcessId

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

◆ QueryRunType

QueryRunType

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

◆ QueryStmtType

QueryStmtType

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

| 72 = CANCEL QUERY

◆ SQLStatementID

SQLStatementID

The second element of the <property>AppMetadataStackID</property> 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)

◆ Server

Server

Identifies the instance on which this SQL Statement is running: <hostname>:<supersever port>

◆ StatementIndexHash

StatementIndexHash

SQL StatementIndex hash of this SQL Statement, which is used as a pointer to.

the internal definition stored in the SQL Statement Index (SSI)

◆ StatementOrder

StatementOrder

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

◆ Status

Status

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

◆ SubStatement

SubStatement

◆ TPNestingLevel

TPNestingLevel

Current nesting level for Transaction Processing (TP)

◆ UserName

UserName

$USERNAME of person who created and invoked this SQL Statement

Static Public Member Functions

Public Attributes

Private Attributes

Additional Inherited Members