Datatypes in Informix

Posted in 2003

ovkrishna — Thu, 16 Oct 2003 12:42:53 -0400 — source: Usenet: comp.databases.informix

Hi, I am trying to obtain an extract of my Informix database into a formatted spreadsheet. The information of the fields in a table is maintained in SYSCOLUMNS table. But the datatype of each column is given by COLTYPE field which is of SMALLINT Type. Which table holds the reference of this datatype name against the number? There is one table SYSXTDTYPES. This contains the extended datatypes. But I could not locate the table for the basic datatypes. Please clarify -- Posted via http://dbforums.com