Home > Class Reference > ENSLIB namespace > INFORMATION.SCHEMA.STATEMENTS

INFORMATION.SCHEMA.STATEMENTS

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

SQL Table Name: INFORMATION_SCHEMA.STATEMENTS

Contains SQL Statement Index entries that can be accessed by the current user in the current namespace.

Property Inventory (Including Private)

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 (Including Private)

relationship Children as array of INFORMATION.SCHEMA.STATEMENTCHILDREN [ InitialExpression = $listbuild("INFORMATION.SCHEMA.STATEMENTCHILDREN","Statement",+$this,"children",1,1) , Transient , Inverse = Statement , Cardinality = children ];
Property methods: ChildrenGet(), ChildrenGetObject(), ChildrenGetObjectId(), ChildrenGetSwizzled(), ChildrenIsEmpty(), ChildrenIsValid(), ChildrenNewObject(), ChildrenRClose(), ChildrenRExec(), ChildrenRFetch(), ChildrenRelate(), ChildrenSQLCompute(), ChildrenSet(), ChildrenUnRelate()
property DefaultSchema as %Library.List;
Value of %defschema when the statement was compiled
Property methods: DefaultSchemaGet(), DefaultSchemaIsValid(), DefaultSchemaLogicalToOdbc(), DefaultSchemaLogicalToXSD(), DefaultSchemaOdbcToLogical(), DefaultSchemaSet(), DefaultSchemaXSDToLogical()
property Error as %String (MAXLEN = 4096);
Error string recorded for this plan
Property methods: ErrorDisplayToLogical(), ErrorGet(), ErrorIsValid(), ErrorLogicalToDisplay(), ErrorLogicalToOdbc(), ErrorNormalize(), ErrorSet()
property Frozen as %Integer;
0/1/2/3 flag which defines if the statement plan Unfrozen (0), Frozen/Explicit (1), Frozen/Upgrade (2), or Unfrozen/Parallel (3)
Property methods: FrozenDifferentDisplayToLogical(), FrozenDifferentGet(), FrozenDifferentIsValid(), FrozenDifferentLogicalToDisplay(), FrozenDifferentLogicalToXSD(), FrozenDifferentNormalize(), FrozenDifferentSet(), FrozenDifferentXSDToLogical(), FrozenDisplayToLogical(), FrozenGet(), FrozenIsValid(), FrozenLogicalToDisplay(), FrozenNormalize(), FrozenScanHashDisplayToLogical(), FrozenScanHashGet(), FrozenScanHashIsValid(), FrozenScanHashLogicalToDisplay(), FrozenScanHashLogicalToOdbc(), FrozenScanHashNormalize(), FrozenScanHashSet(), FrozenScanVersionDisplayToLogical(), FrozenScanVersionGet(), FrozenScanVersionIsValid(), FrozenScanVersionLogicalToDisplay(), FrozenScanVersionLogicalToOdbc(), FrozenScanVersionNormalize(), FrozenScanVersionSet(), FrozenSet(), FrozenXSDToLogical()
property FrozenDifferent as %Boolean;
True if the frozen plan is different to what we would use if the plan was not frozen
Property methods: FrozenDifferentDisplayToLogical(), FrozenDifferentGet(), FrozenDifferentIsValid(), FrozenDifferentLogicalToDisplay(), FrozenDifferentLogicalToXSD(), FrozenDifferentNormalize(), FrozenDifferentSet(), FrozenDifferentXSDToLogical()
property Hash as %String (MAXLEN = 32) [ Required ];
Internal unique statement hash used as the ID for the statement.
Property methods: HashDisplayToLogical(), HashGet(), HashIsValid(), HashLogicalToDisplay(), HashLogicalToOdbc(), HashNormalize(), HashSet()
relationship Locations as array of INFORMATION.SCHEMA.STATEMENTLOCATIONS (XMLPROJECTION = "NONE") [ InitialExpression = $listbuild("INFORMATION.SCHEMA.STATEMENTLOCATIONS","Statement",+$this,"children",1,1) , Transient , Inverse = Statement , Cardinality = children ];
Property methods: LocationsGet(), LocationsGetObject(), LocationsGetObjectId(), LocationsGetSwizzled(), LocationsIsEmpty(), LocationsIsValid(), LocationsNewObject(), LocationsRClose(), LocationsRExec(), LocationsRFetch(), LocationsRelate(), LocationsSQLCompute(), LocationsSet(), LocationsUnRelate()
property NaturalQuery as %Boolean;
Set to true for 'natural' queries which are already maximally efficient and for which we do not collect any statistics as the overhead of statistical collection would have a significant impact on the statement performance.
Property methods: NaturalQueryDisplayToLogical(), NaturalQueryGet(), NaturalQueryIsValid(), NaturalQueryLogicalToDisplay(), NaturalQueryLogicalToXSD(), NaturalQueryNormalize(), NaturalQuerySet(), NaturalQueryXSDToLogical()
property Packages as %Library.List;
Value of packages argument passed to SQL compiler when the statement was compiled
Property methods: PackagesGet(), PackagesIsValid(), PackagesLogicalToOdbc(), PackagesLogicalToXSD(), PackagesOdbcToLogical(), PackagesSet(), PackagesXSDToLogical()
property ParentHash as %String (MAXLEN = 32) [ Required ];
Hash of this statement's parent statement. Only defined if this is a recursive compile for %PARALLEL statements. This references the root parent's hash.
Property methods: ParentHashDisplayToLogical(), ParentHashGet(), ParentHashIsValid(), ParentHashLogicalToDisplay(), ParentHashLogicalToOdbc(), ParentHashNormalize(), ParentHashSet()
property Plan as list of %Binary (MAXLEN = 65536);
Query plan
Property methods: PlanBuildValueArray(), PlanCollectionToDisplay(), PlanCollectionToOdbc(), PlanDisplayToCollection(), PlanGet(), PlanGetObject(), PlanGetObjectId(), PlanGetSwizzled(), PlanIsValid(), PlanLogicalToXSD(), PlanOdbcToCollection(), PlanSet(), PlanSetObject(), PlanSetObjectId(), PlanXSDToLogical()
relationship PrivilegeRelations as array of INFORMATION.SCHEMA.STATEMENTPRIVOBJECTS [ InitialExpression = $listbuild("INFORMATION.SCHEMA.STATEMENTPRIVOBJECTS","Statements",+$this,"children",1,1) , Transient , Inverse = Statements , Cardinality = children ];
Property methods: PrivilegeRelationsGet(), PrivilegeRelationsGetObject(), PrivilegeRelationsGetObjectId(), PrivilegeRelationsGetSwizzled(), PrivilegeRelationsIsEmpty(), PrivilegeRelationsIsValid(), PrivilegeRelationsNewObject(), PrivilegeRelationsRClose(), PrivilegeRelationsRExec(), PrivilegeRelationsRFetch(), PrivilegeRelationsRelate(), PrivilegeRelationsSQLCompute(), PrivilegeRelationsSet(), PrivilegeRelationsUnRelate()
relationship Relations as array of INFORMATION.SCHEMA.STATEMENTRELATIONS [ InitialExpression = $listbuild("INFORMATION.SCHEMA.STATEMENTRELATIONS","Statement",+$this,"children",1,1) , Transient , Inverse = Statement , Cardinality = children ];
Property methods: RelationsGet(), RelationsGetObject(), RelationsGetObjectId(), RelationsGetSwizzled(), RelationsIsEmpty(), RelationsIsValid(), RelationsNewObject(), RelationsRClose(), RelationsRExec(), RelationsRFetch(), RelationsRelate(), RelationsSQLCompute(), RelationsSet(), RelationsUnRelate()
property SQLSchemaPath as %Library.List;
Value of %sqlSchemaPath when the statement was compiled
Property methods: SQLSchemaPathGet(), SQLSchemaPathIsValid(), SQLSchemaPathLogicalToOdbc(), SQLSchemaPathLogicalToXSD(), SQLSchemaPathOdbcToLogical(), SQLSchemaPathSet(), SQLSchemaPathXSDToLogical()
property SqlComp as %String (MAXLEN = 32);
SQL Compilation mode, Logical, Odbc, Display, Runtime, etc., when the statement was compiled
Property methods: SqlCompDisplayToLogical(), SqlCompGet(), SqlCompIsValid(), SqlCompLogicalToDisplay(), SqlCompLogicalToOdbc(), SqlCompNormalize(), SqlCompSet()
property StatAverage as %Double [ Calculated ];
Average time spent running this query
Property methods: StatAverageCompute(), StatAverageDisplayToLogical(), StatAverageGet(), StatAverageIsValid(), StatAverageLogicalToDisplay(), StatAverageLogicalToXSD(), StatAverageNormalize(), StatAverageOdbcToLogical(), StatAverageSQLCompute(), StatAverageXSDToLogical()
property StatCount as %Integer;
Total number of times we have recorded this query being run
Property methods: StatCountDisplayToLogical(), StatCountGet(), StatCountIsValid(), StatCountLogicalToDisplay(), StatCountNormalize(), StatCountSet(), StatCountXSDToLogical()
property StatFirst as %Date;