persistent class %XSQL.Catalog.Informix.syscolumns
extends %Persistent
Contains one row for every column in every table and view, and a row for each parameter in a stored procedure.
• parameter READONLY = 1;
READONLY = 1 means that objects can be created, opened but not saved or deleted.
Tables are projected to SQL as READONLY.
• property colname
as %String(MAXLEN=128);
Name of the column
• property colno
as %SmallInt [ Transient ];
Column number sequentially assigned by the system (from left to right within each table)
• 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 maxlen
as %Integer;
Maximum column length (in bytes)
• property tabid
as %Integer;
Object ID of the table to which this column belongs
•index (IDKEYIndex on tabid,colid) [IdKey,Unique];
