Skip to main content

%SYS.SQLObjectQuery

SQL Table Name: %SYS.SQLObjectQuery

Property Inventory

Method Inventory

Properties

property library as %Integer [ InitialExpression = 9 , Required ];
Property methods: libraryDisplayToLogical(), libraryGet(), libraryGetStored(), libraryIsValid(), libraryLogicalToDisplay(), libraryNormalize(), librarySet()
property queryName as %String) [ Required ];
Property methods: queryNameDisplayToLogical(), queryNameGet(), queryNameGetStored(), queryNameIsValid(), queryNameLogicalToDisplay(), queryNameLogicalToOdbc(), queryNameNormalize(), queryNameSet()
property statement as %String);
Property methods: statementDisplayToLogical(), statementGet(), statementGetStored(), statementIsValid(), statementLogicalToDisplay(), statementLogicalToOdbc(), statementNormalize(), statementSet()
property targetClass as %String);
Property methods: targetClassDisplayToLogical(), targetClassGet(), targetClassGetStored(), targetClassIsValid(), targetClassLogicalToDisplay(), targetClassLogicalToOdbc(), targetClassNormalize(), targetClassSet()

Methods

classmethod %AddQuery(pQueryName, pTargetClass, pQueryText) as %Status [ SQLProc = jpa_add_named_query ]
Projected as the stored procedure: jpa_add_named_query
classmethod %DeleteQuery(pQueryName) as %Status [ SQLProc = jpa_delete_named_query ]
Projected as the stored procedure: jpa_delete_named_query
classmethod %Prepare(pQueryName As %String(MAXLEN="")="", pTargetClass As %String(MAXLEN="")="", %args) as %Library.IResultSet
%Prepare() This method is responsible for accepting an SQL statement and preparing an instance of the implementation of that statement. The implementation is a class that is a subclass of the statement type class ( CALL = %ProcedureContext, CURSOR = result set, etc) The first task of prepare is to lookup the statement in the prepared statement cache by calling the XSQL Cache Manager. The cache manager might call back into the %XSQL statement class to generate a new implementation.

Indexes

index (IDK on library,queryName) [IdKey, Type = key];
Index methods: IDKCheck(), IDKDelete(), IDKExists(), IDKOpen(), IDKSQLCheckUnique(), IDKSQLExists(), IDKSQLFindPKeyByConstraint(), IDKSQLFindRowIDByConstraint()

Inherited Members

Inherited Methods

Storage

Storage Model: CacheStorage (%SYS.SQLObjectQuery)

^%sqlcq($zu(5),"Query")(ID)
=
library
queryName
targetClass
statement
%%CLASSNAME
FeedbackOpens in a new tab