Re: Datatypes in Informix

Posted in 2003

Obnoxio The Clown — Thu, 16 Oct 2003 19:09:21 +0100 — source: Usenet: comp.databases.informix

ovkrishna wrote: > 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. If you look in the software section of the IIUG.org website, you should find some code that will show you what to do. -- Ciao, The Obnoxious One "Ogni uomo mi guarda come se fossi una testa di cazzo"