%SYS.SQLObjectQuery
hidden persistent class %SYS.SQLObjectQuery extends %Library.Persistent
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
- %%CLASSNAMELogicalToStorage()
- %%CLASSNAMEStorageToLogical()
- %AddToSaveSet()
- %AddToSyncSet()
- %BMEBuilt()
- %BuildIndicesAsync()
- %BuildIndicesAsyncResponse()
- %CheckConstraints()
- %CheckConstraintsForExtent()
- %ClassIsLatestVersion()
- %ClassName()
- %ComposeOid()
- %ConstructClone()
- %Delete()
- %DeleteExtent()
- %DeleteId()
- %DispatchClassMethod()
- %DispatchGetModified()
- %DispatchGetProperty()
- %DispatchMethod()
- %DispatchSetModified()
- %DispatchSetMultidimProperty()
- %DispatchSetProperty()
- %Exists()
- %ExistsId()
- %Extends()
- %GUID()
- %GUIDSet()
- %GetLock()
- %GetParameter()
- %GetSwizzleObject()
- %Id()
- %InsertBatch()
- %IsA()
- %IsModified()
- %IsNull()
- %KillExtent()
- %KillExtentData()
- %LoadFromMemory()
- %LockExtent()
- %LockId()
- %New()
- %NormalizeObject()
- %ObjectIsNull()
- %ObjectModified()
- %Oid()
- %OnBeforeAddToSync()
- %OnDeleteFinally()
- %OnDetermineClass()
- %OnOpenFinally()
- %OnSaveFinally()
- %Open()
- %OpenId()
- %OriginalNamespace()
- %PackageName()
- %PhysicalAddress()
- %PurgeIndices()
- %Reload()
- %RemoveFromSaveSet()
- %ResolveConcurrencyConflict()
- %RollBack()
- %Save()
- %SaveDirect()
- %SaveIndices()
- %SerializeObject()
- %SetModified()
- %SortBegin()
- %SortEnd()
- %SyncObjectIn()
- %SyncTransport()
- %UnlockExtent()
- %UnlockId()
- %ValidateIndices()
- %ValidateObject()
- %ValidateTable()
Storage
Storage Model: Storage (%SYS.SQLObjectQuery)
^%sqlcq($namespace,"Query")(ID) |
= | library
queryName
targetClass
statement
%%CLASSNAME
|