Class Reference
IRIS for UNIX 2019.2
InterSystems: The power behind what matters   
Documentation  Search
  [ENSLIB] >  [%SYS] >  [SQLObjectQuery]
Private  Storage   


Parameters Properties Methods Queries Indices ForeignKeys Triggers
4 3 1


library queryName statement targetClass

%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


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


• 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.


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

Copyright (c) 2019 by InterSystems Corporation. Cambridge, Massachusetts, U.S.A. All rights reserved. Confidential property of InterSystems Corporation.