Class Reference
Cache for UNIX 2018.1.3
InterSystems: The power behind what matters   
Documentation  Search
Private  Storage  

persistent class %BI.StoredProc extends %Persistent, %XML.Adaptor

Inventory

Parameters Properties Methods Queries Indices ForeignKeys Triggers
7 3 1


Summary

Properties
cls descr fldr help nm
param proc

Methods
%AddToSaveSet %AddToSyncSet %BMEBuilt %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 %OnDetermineClass
%Open %OpenId %OriginalNamespace %PackageName
%PhysicalAddress %PurgeIndices %Reload %RemoveFromSaveSet
%ResolveConcurrencyConflict %RollBack %Save %SaveDirect
%SaveIndices %SerializeObject %SetModified %SortBegin
%SortEnd %SyncObjectIn %SyncTransport %UnlockExtent
%UnlockId %ValidateIndices %ValidateObject XMLDTD
XMLExport XMLExportToStream XMLExportToString XMLNew
XMLSchema XMLSchemaNamespace XMLSchemaType


Properties

• property cls as %String(TRUNCATE=1);
• property descr as %String(MAXLEN=10000,TRUNCATE=1);
• property fldr as %String(TRUNCATE=1);
• property help as %String(TRUNCATE=1);
• property nm as %String(TRUNCATE=1);
• property param as %String(MAXLEN=10000,TRUNCATE=1);
• property proc as %String(TRUNCATE=1);

Queries

• query ListByFldr(fldr As %String)
SQL Query :
SELECT %ID,nm FROM StoredProc
WHERE (fldr = :fldr)
ORDER BY nm
• query ListFolder(folder)
SQL Query :
SELECT ID,nm
FROM %BI.StoredProc
WHERE (fldr = :folder)
ORDER BY nm
• query ListProc()
SQL Query :
SELECT ID,nm,fldr
FROM %BI.StoredProc
ORDER BY nm

Indices

• index (Name on nm:Exact);


Copyright © 1997-2019, InterSystems Corporation