Interpreting syscolumns table
Ed Brown asked how to interpret coltype and collength in syscolumns, especially for money, decimal and datetime. A poster pointed to the Informix Guide to SQL: Reference, and Paul Watson said the manual and a demo-directory program could translate them into DDL. Art S. Kagel pointed to 4GL and ESQL/C functions in the IIUG repository and to the source of his myschema utility. Answered with references.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
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
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 > >
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 #
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