Interpreting syscolumns table

Posted in 2000

Ed Brown — Mon, 18 Sep 2000 08:21:37 -0500 — source: Informix-list mailing list archive (1991-1998)

Does anyone know, or know where I could find, information on how to intrepret the coltype and collength columns of the syscolumns system catalog table? Some of the values are obvious, some aren't (especially collength for money, decimal, datetime, etc.). thanks in advance, Ed Brown

↪ replying to Ed Brown

remove (_at_) to reply — Mon, 18 Sep 2000 15:54:19 +0200 — source: Informix-list mailing list archive (1991-1998)

Try with Informix Guide to SQL: Reference, December 1999 in Answers OnLine. Nebojsa On Mon, 18 Sep 2000 08:21:37 -0500, "Ed Brown" <ebrown@computer-systems.com> wrote: >Does anyone know, or know where I could find, information on how to >intrepret the coltype and collength columns of the syscolumns system catalog >table? Some of the values are obvious, some aren't (especially collength for >money, decimal, datetime, etc.). > >thanks in advance, > >Ed Brown > >

↪ replying to Ed Brown

Paul Watson — Mon, 18 Sep 2000 15:46:14 +0100 — source: Informix-list mailing list archive (1991-1998)

RTFM is a good one, also there is/was in the demo directory some code that would translate these in to DDL for you Most of the standard Informix resource sites have something that will convert the collength/coltype into english Ed Brown wrote: > > Does anyone know, or know where I could find, information on how to > intrepret the coltype and collength columns of the syscolumns system catalog > table? Some of the values are obvious, some aren't (especially collength for > money, decimal, datetime, etc.). > > thanks in advance, > > Ed Brown -- Paul Watson # WF Software Ltd # You are only young once Tel: +44 1436 674729 # but you can be immature Fax: +44 1436 678693 # for ever www.wfsoftware.com #

↪ replying to Ed Brown

Art S. Kagel — Mon, 18 Sep 2000 16:17:59 -0400 — source: Informix-list mailing list archive (1991-1998)

In addition to the references given already: In the IIUG Repository are two functions to do that interpretation one in 4GL the other in ESQL/C and you can look at the main file of the source to my dbschema replacement utility, myschema, myschema.ec, which is in the package utils2_ak and see how it is done there. Art S. Kagel Ed Brown wrote: > > Does anyone know, or know where I could find, information on how to > intrepret the coltype and collength columns of the syscolumns system catalog > table? Some of the values are obvious, some aren't (especially collength for > money, decimal, datetime, etc.). > > thanks in advance, > > Ed Brown