Home > Class Reference > ENSLIB namespace > %SYS.SQLObjectQuery
Private  Storage   

%SYS.SQLObjectQuery


Inventory


Parameters Properties Methods Queries Indices ForeignKeys Triggers
4 3 1


Summary


Properties
library queryName statement targetClass

Methods
%AddQuery %AddToSaveSet %AddToSyncSet %BMEBuilt
%CheckConstraints %CheckConstraintsForExtent %ClassIsLatestVersion %ClassName
%ComposeOid %ConstructClone %Delete %DeleteExtent
%DeleteId %DeleteQuery %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 %OnDetermineClass %Open %OpenId
%OriginalNamespace %PackageName %PhysicalAddress %Prepare
%PurgeIndices %Reload %RemoveFromSaveSet %ResolveConcurrencyConflict
%RollBack %Save %SaveDirect %SaveIndices
%SerializeObject %SetModified %SortBegin %SortEnd
%SyncObjectIn %SyncTransport %UnlockExtent %UnlockId
%ValidateIndices %ValidateObject


Properties


• property library as %Integer [ InitialExpression = 9 ];
• property queryName as %String(MAXLEN="");
• property statement as %String(MAXLEN="");
• property targetClass as %String(MAXLEN="");

Methods


• classmethod %AddQuery(pQueryName, pTargetClass, pQueryText) as %Status [ SQLProc = jpa_add_named_query ]
• classmethod %DeleteQuery(pQueryName) as %Status [ SQLProc = 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.

Indices


•index (IDK on library,queryName) [IdKey];