Hello, can someone please give me a hint, where to find the meaning of the coltype column in syscolumns?
select coltype, count(coltype)
FROM "informix".systables t, "informix".syscolumns c
WHERE t.tabid = c.tabid
AND t.tabtype = 'T' -- exclude views, synonyms, etc.
AND t.tabid >= 100 -- exclude the system catalog
group by coltype
order by coltype
coltype speaks by itself: it means the datatype of the column :-)
each column has a datatype, ranging from usual ones ( integer, smallint, serial, float, smallfloat, date, datetime, decimal, char, varchar, nchar), and custom or opaque ones used generally for datablades or custom functions ( blob,clob, text,byte etc...)
Each coltype value refers either to a specific type ( integer, smallint etc...), or variable one using a formula on this number ( char, varchar, datetime etc).
You can find the definition of those type in $INFORMIXDIR/incl/public/sqltypes.h
The variable types generally use a algoryth based on modulo 256 to get the data type and length.