Re: Datatypes in Informix

Posted in 2003

Jean Sagi — Sun, 19 Oct 2003 16:47:30 -0500 — source: Usenet: comp.databases.informix

Interesting article. But it covers very simple catalog tables... does anyone know of a similar article which describes the pseudo-tables in newer versions of the engine? Chucho! Jack Parker wrote: > 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 > > -- Atte, Jes's Antonio Santos Giraldo jeansagi@myrealbox.com jeansagi@netscape.net sending to informix-list