Re: Datatypes in Informix

Posted in 2003

Jack Parker — Thu, 16 Oct 2003 16:43:40 -0400 — source: Usenet: comp.databases.informix

http://www7b.software.ibm.com/dmdd/zones/informix/library/techarticle/0305pa rker/0305parker.html#top cheers j. -.-- --- ..- / -. . . -.. / - --- / --. . - / .- / .-.. .. ..-. . .-.-.- / ... --- / -.. --- / .. .-.-.- ----- Original Message ----- From: "ovkrishna" <member44474@dbforums.com> To: <informix-list@iiug.org> Sent: Thursday, October 16, 2003 12:42 PM Subject: Datatypes in 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 > sending to informix-list