%XSQL.Catalog.Informix.syscolumns
persistent class %XSQL.Catalog.Informix.syscolumns extends %Library.Persistent
SQL Table Name: %XSQL_Catalog_Informix.syscolumns
Contains one row for every column in every table and view, and a row for each parameter in a stored procedure.Property Inventory
Parameters
parameter READONLY = 1;
Inherited description: READONLY = 1 means that objects can be created, opened but not saved or deleted.
Tables are projected to SQL as READONLY.
Properties
property colname as %String (MAXLEN = 128);
Name of the column
Property methods: colnameDisplayToLogical(), colnameGet(), colnameIsValid(), colnameLogicalToDisplay(), colnameLogicalToOdbc(), colnameNormalize(), colnameSet()
property colno as %SmallInt [ Transient ];
Column number sequentially assigned by the system (from left to right within each table)
Property methods: colnoCompute(), colnoDisplayToLogical(), colnoGet(), colnoIsValid(), colnoLogicalToDisplay(), colnoNormalize(), colnoSQLCompute(), colnoSet(), colnoSetT()
property coltype as %SmallInt [ Transient ];
Code (identifier) for column data type:
0 = CHAR 14 = INTERVAL
1 = SMALLINT 15 = NCHAR
2 = INTEGER 16 = NVARCHAR
3 = FLOAT 17 = INT8
4 = SMALLFLOAT 18 = SERIAL8*
5 = DECIMAL 19 = SET
6 = SERIAL* 20 = MULTISET
7 = DATE 21 = LIST
8 = MONEY 22 = ROW
9 = NULL 23 = COLLECTION
10 = DATETIME 24 = ROWREF
11 = BYTE 40 = Variable-length opaque type
12 = TEXT 41 = Fixed-length opaque type
13 = VARCHAR 4118 = Named row type
Property methods: coltypeCompute(), coltypeDisplayToLogical(), coltypeGet(), coltypeIsValid(), coltypeLogicalToDisplay(), coltypeNormalize(), coltypeSQLCompute(), coltypeSet(), coltypeSetT()
property maxlen as %Integer;
Maximum column length (in bytes)
Property methods: maxlenDisplayToLogical(), maxlenGet(), maxlenIsValid(), maxlenLogicalToDisplay(), maxlenNormalize(), maxlenSet()
property tabid as %Integer [ Required ];
Object ID of the table to which this column belongs
Property methods: tabidDisplayToLogical(), tabidGet(), tabidIsValid(), tabidLogicalToDisplay(), tabidNormalize(), tabidSet()
Indexes
index (IDKEYIndex on tabid,colid) [IdKey, Type = key, Unique];
Index methods: IDKEYIndexCheck(), IDKEYIndexDelete(), IDKEYIndexExists(), IDKEYIndexOpen(), IDKEYIndexSQLCheckUnique(), IDKEYIndexSQLExists(), IDKEYIndexSQLFindPKeyByConstraint(), IDKEYIndexSQLFindRowIDByConstraint()
Inherited Members
Inherited Methods
- %AddToSaveSet()
- %AddToSyncSet()
- %BuildDeferredIndices()
- %BuildIndicesAsync()
- %BuildIndicesAsyncResponse()
- %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()
- %IsA()
- %IsModified()
- %IsNull()
- %KillExtent()
- %LockExtent()
- %LockId()
- %New()
- %NormalizeObject()
- %ObjectIsNull()
- %ObjectModified()
- %Oid()
- %OnBeforeAddToSync()
- %OnDeleteFinally()
- %OnDetermineClass()
- %OnOpenFinally()
- %OnSaveFinally()
- %Open()
- %OpenId()
- %OriginalNamespace()
- %PackageName()
- %PurgeIndices()
- %Reload()
- %RemoveFromSaveSet()
- %ResolveConcurrencyConflict()
- %RollBack()
- %Save()
- %SaveDirect()
- %SerializeObject()
- %SetModified()
- %SortBegin()
- %SortEnd()
- %SyncObjectIn()
- %SyncTransport()
- %UnlockExtent()
- %UnlockId()
- %ValidateIndices()
- %ValidateObject()
- %ValidateTable()
Storage
Storage Model: SQLStorage
Maps: 2
Map number 1 is named Master
thismap.Global: ^oddTSQL
Map number 2 is named SchemaNameIndex
thismap.Global: ^oddSQL
^oddTSQL({tabid},"col",{colid})
|
= |
|
^oddSQL({schema},{parent_obj_name},"tsql",1,{tabid},"col",{colid})
|
= |
|