Home > Class Reference > ENSLIB namespace > %XSQL.Catalog.Informix.syscolumns

%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 (Including Private)

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

property colid as %Integer [ Private , Required ];
Internal Column id value
Property methods: colidDisplayToLogical(), colidGet(), colidIsValid(), colidLogicalToDisplay(), colidNormalize(), colidSet()
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 parentobjname as %String (MAXLEN = 128) [ Private , SqlFieldName = parent_obj_name ];
Parent Object name Object name of the parent_obj.
Property methods: parentobjnameDisplayToLogical(), parentobjnameGet(), parentobjnameIsValid(), parentobjnameLogicalToDisplay(), parentobjnameLogicalToOdbc(), parentobjnameNormalize(), parentobjnameSet()
property schema as %String (MAXLEN = 128) [ Private ];
Name of the schema the column resides in
Property methods: schemaDisplayToLogical(), schemaGet(), schemaIsValid(), schemaLogicalToDisplay(), schemaLogicalToOdbc(), schemaNormalize(), schemaSet()
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 (Including Private)