INFORMATION.SCHEMA.STATEMENTLOCATIONS

Class INFORMATION.SCHEMA.STATEMENTLOCATIONS Extends (%Library.Persistent, %XML.Adaptor) [ ClassType = persistent, Final, Owner = {_PUBLIC}, SqlRowIdPrivate, SqlTableName = STATEMENT_LOCATIONS, StorageStrategy = SQLStorage, System = 4 ]

Returns one row location (routine, class) that has an SQL Statement. This is a child table of INFORMATION_SCHEMA.STATEMENTS as a statement may be found in multiple locations.

Parameters

READONLY

Parameter READONLY = 1;

Properties

Statement

Relationship Statement As INFORMATION.SCHEMA.STATEMENTS [ Cardinality = parent, Inverse = Locations ];

Parent reference to the SQL Statement

Location

Property Location As %String(MAXLEN = 128) [ Required ];

Routine or classname the SQL Statement reside in

RuntimeLocation

Property RuntimeLocation As %String(MAXLEN = 128);

Runtime location of SQL logic, for universal cached queries will be different to Location

Type

Property Type As %String(MAXLEN = 10);

Type of location: Class (CLS), Routine (RTN), etc.