Skip to main content

%XSQL.Catalog.Informix.syscolumns

Class %XSQL.Catalog.Informix.syscolumns Extends %Persistent [ SqlRowIdPrivate, StorageStrategy = SQLStorage, System = 4 ]

Contains one row for every column in every table and view, and a row for each parameter in a stored procedure.

Parameters​

READONLY​

Parameter READONLY = 1;

Properties​

colname​

Property colname As %String(MAXLEN = 128) [ SqlColumnNumber = 2 ];

Name of the column

tabid​

Property tabid As %Integer [ SqlColumnNumber = 3 ];

Object ID of the table to which this column belongs

colno​

Property colno As %SmallInt [ SqlColumnNumber = 4, SqlComputeCode = {Set {colno}=$Listget($Get(^oddEXTR({extentname},"b",{colname},91)),1)}, SqlComputed, Transient ];

Column number sequentially assigned by the system (from left to right within each table)

coltype​

Property coltype As %SmallInt [ SqlColumnNumber = 5, SqlComputeCode = {New data Set data=$ListGet($Get(^oddEXTR({extentname},"b",{colname},91)),9)

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

maxlen​

Property maxlen As %Integer [ SqlColumnNumber = 10 ];

Maximum column length (in bytes)

schema​

Property schema As %String(MAXLEN = 128) [ Private, SqlColumnNumber = 12 ];

Name of the schema the column resides in

colid​

Property colid As %Integer [ Private, SqlColumnNumber = 13 ];

Internal Column id value

parentobjname​

Property parentobjname As %String(MAXLEN = 128) [ Private, SqlColumnNumber = 14, SqlFieldName = parent_obj_name ];

Parent Object name Object name of the parent_obj.

extentname​

Property extentname As %String(MAXLEN = 128) [ Internal, Private, SqlColumnNumber = 15, SqlComputeCode = { Set {extentname}=$ListGet($Get(^rINDEXSQL("rv",$zcvt($Listget($Get(^oddTSQL({tabid}))),"U"),$zcvt($Listget($Get(^oddTSQL({tabid})),2),"U"))),2)}, SqlComputed, Transient ];

Name of the extent that projected this table