This is documentation for Caché & Ensemble.

For information on converting to InterSystems IRIS, see the InterSystems IRIS Adoption Guide and the InterSystems IRIS In-Place Conversion Guide, both available on the WRC Distributions page (login required).

Home > Class Reference > %SYS namespace > %BI.StoredProc


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

SQL Table Name: %BI.StoredProc

Property Inventory (Including Private)

Properties (Including Private)

property cls as %String (TRUNCATE = 1);
Property methods: clsDisplayToLogical(), clsGet(), clsGetStored(), clsIsValid(), clsLogicalToDisplay(), clsLogicalToOdbc(), clsNormalize(), clsSet()
property descr as %String (MAXLEN = 10000, TRUNCATE = 1);
Property methods: descrDisplayToLogical(), descrGet(), descrGetStored(), descrIsValid(), descrLogicalToDisplay(), descrLogicalToOdbc(), descrNormalize(), descrSet()
property fldr as %String (TRUNCATE = 1);
Property methods: fldrDisplayToLogical(), fldrGet(), fldrGetStored(), fldrIsValid(), fldrLogicalToDisplay(), fldrLogicalToOdbc(), fldrNormalize(), fldrSet()
property help as %String (TRUNCATE = 1);
Property methods: helpDisplayToLogical(), helpGet(), helpGetStored(), helpIsValid(), helpLogicalToDisplay(), helpLogicalToOdbc(), helpNormalize(), helpSet()
property nm as %String (TRUNCATE = 1);
Property methods: nmDisplayToLogical(), nmGet(), nmGetStored(), nmIsValid(), nmLogicalToDisplay(), nmLogicalToOdbc(), nmNormalize(), nmSet()
property param as %String (MAXLEN = 10000, TRUNCATE = 1);
Property methods: paramDisplayToLogical(), paramGet(), paramGetStored(), paramIsValid(), paramLogicalToDisplay(), paramLogicalToOdbc(), paramNormalize(), paramSet()
property proc as %String (TRUNCATE = 1);
Property methods: procDisplayToLogical(), procGet(), procGetStored(), procIsValid(), procLogicalToDisplay(), procLogicalToOdbc(), procNormalize(), procSet()


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


index (Name on nm:Exact);
Index methods: NameExists()

Inherited Members

Inherited Methods (Including Private)


Storage Model: CacheStorage (%BI.StoredProc)