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

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];


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