Re: Datatypes in Informix

On Thu, 16 Oct 2003 12:42:53 -0400, ovkrishna wrote: The datatypes are only documented in the docs and in the 'C' header file sqltypes.h under $INFORMIXDIR/incl Art S. Kagel > 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