Skip to main content

INFORMATION.SCHEMA.STATEMENTLOCATIONS

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

SQL Table Name: INFORMATION_SCHEMA.STATEMENT_LOCATIONS

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.

Property Inventory

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 Location as %String (MAXLEN = 128) [ Required ];
Routine or classname the SQL Statement reside in
Property methods: LocationDisplayToLogical(), LocationGet(), LocationIsValid(), LocationLogicalToDisplay(), LocationLogicalToOdbc(), LocationNormalize(), LocationSet()
property RuntimeLocation as %String (MAXLEN = 128);
Runtime location of SQL logic, for universal cached queries will be different to Location
Property methods: RuntimeLocationDisplayToLogical(), RuntimeLocationGet(), RuntimeLocationIsValid(), RuntimeLocationLogicalToDisplay(), RuntimeLocationLogicalToOdbc(), RuntimeLocationNormalize(), RuntimeLocationSet()
relationship Statement as INFORMATION.SCHEMA.STATEMENTS [ Required , Inverse = Locations , Cardinality = parent ];
Parent reference to the SQL Statement
Property methods: StatementGet(), StatementGetObject(), StatementGetObjectId(), StatementGetSwizzled(), StatementIsValid(), StatementNewObject(), StatementOnDelete(), StatementRClose(), StatementRExec(), StatementRFetch(), StatementRelate(), StatementSQLCompute(), StatementSet(), StatementSetObject(), StatementSetObjectId(), StatementUnRelate(), StatementUnSwizzle()
property Type as %String (MAXLEN = 10);
Type of location: Class (CLS), Routine (RTN), etc.
Property methods: TypeDisplayToLogical(), TypeGet(), TypeIsValid(), TypeLogicalToDisplay(), TypeLogicalToOdbc(), TypeNormalize(), TypeSet()

Indexes

index (StatementRelationsIDKey on Location) [IdKey, Type = key];
Index methods: StatementRelationsIDKeyCheck(), StatementRelationsIDKeyDelete(), StatementRelationsIDKeyExists(), StatementRelationsIDKeyOpen(), StatementRelationsIDKeySQLCheckUnique(), StatementRelationsIDKeySQLExists(), StatementRelationsIDKeySQLFindPKeyByConstraint(), StatementRelationsIDKeySQLFindRowIDByConstraint()

Inherited Members

Inherited Methods

Storage

Gray indicates storage defined by superclasses.

Storage Model: SQLStorage

Maps: 2

  • Map number 1 is named LocationIndex

    thismap.Global: ^rINDEXSQL

  • Map number 2 is named Master

    thismap.Global: ^rINDEXSQL

  • ^rINDEXSQL("sqlidx",2,{Location},{INFORMATION_SCHEMA.STATEMENTS.Hash})
    =
    ^rINDEXSQL("sqlidx",1,{INFORMATION_SCHEMA.STATEMENTS.Hash},"rtn",{Location})
    =
    Node Delimiter Piece Name
    1 Type
    2 RuntimeLocation
FeedbackOpens in a new tab