Skip to main content

%BI.StoredProc

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

SQL Table Name: %BI.StoredProc

Property Inventory

Properties

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()

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

Indexes

index (IDKEY on ) [IdKey, Type = key];
Index methods: IDKEYCheck(), IDKEYDelete(), IDKEYExists(), IDKEYOpen(), IDKEYSQLCheckUnique(), IDKEYSQLExists(), IDKEYSQLFindPKeyByConstraint(), IDKEYSQLFindRowIDByConstraint()
index (Name on nm:Exact);
Index methods: NameExists()

Inherited Members

Inherited Methods

Storage

Storage Model: CacheStorage (%BI.StoredProc)

^BI.StoredProcD(ID)
=
%%CLASSNAME
cls
descr
fldr
nm
param
proc
help
FeedbackOpens in a new tab