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 > ENSLIB namespace > %BI.CodeTable

%BI.CodeTable

persistent class %BI.CodeTable extends %Library.Persistent

SQL Table Name: %BI.CodeTable

Property Inventory (Including Private)

Properties (Including Private)

property Code as %String (TRUNCATE = 1) [ Required ];
Property methods: CodeDisplayToLogical(), CodeGet(), CodeGetStored(), CodeIsValid(), CodeLogicalToDisplay(), CodeLogicalToOdbc(), CodeNormalize(), CodeSet()
property Data as %List;
Property methods: DataGet(), DataGetStored(), DataIsValid(), DataLogicalToOdbc(), DataOdbcToLogical(), DataSet()
property Type as %String (TRUNCATE = 1) [ Required ];
Property methods: TypeAllClose(), TypeAllExecute(), TypeAllFetch(), TypeAllFetchRows(), TypeAllFunc(), TypeAllGetInfo(), TypeAllGetODBCInfo(), TypeAllPrepare(), TypeAllSendODBC(), TypeDisplayToLogical(), TypeGet(), TypeGetStored(), TypeIsValid(), TypeLogicalToDisplay(), TypeLogicalToOdbc(), TypeNormalize(), TypeSet()

Queries

query ByType(Type As %String)
SQL Query:
SELECT Code,Data FROM CodeTable WHERE (Type = :Type) ORDER BY Code
query TypeAll()
SQL Query:
SELECT %ID,Type FROM CodeTable GROUP BY Type

Indexes

index (MainIndex on Type,Code) [IdKey, Type = key, Unique];
Index methods: MainIndexCheck(), MainIndexDelete(), MainIndexExists(), MainIndexOpen(), MainIndexSQLCheckUnique(), MainIndexSQLExists(), MainIndexSQLFindPKeyByConstraint(), MainIndexSQLFindRowIDByConstraint()

Inherited Members

Inherited Methods (Including Private)

Storage

Storage Model: CacheStorage (%BI.CodeTable)

^BI.CodeTableD(ID,"X")
=
%%CLASSNAME

Storage Model: CacheStorage (%BI.CodeTable)

^BI.CodeTableD(ID,n)
=
Data(n)
FeedbackOpens in a new window