Datatypes in Informix

[ovkrishna]

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 [url]http://dbforums.com[/url]

[Obnoxio The Clown]

ovkrishna wrote:

> 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.

If you look in the software section of the IIUG.org website, you should find
some code that will show you what to do.

--
Ciao,
The Obnoxious One

"Ogni uomo mi guarda come se fossi una testa di cazzo"

[Jack Parker]

[url]http://www7b.software.ibm.com/dmdd/zones/informix/library/techarticle/0305pa[/url]
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 [url]http://dbforums.com[/url]
>

sending to informix-list

[fellfrosh]

> 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?

Read the "Informix Guide to SQL: Reference" (Structure of the System Catalog).

Cheers,
Lars

[Art S. Kagel]

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 [url]http://dbforums.com[/url]

[Jean Sagi]

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:

> [url]http://www7b.software.ibm.com/dmdd/zones/informix/library/techarticle/0305pa[/url]
> 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 [url]http://dbforums.com[/url]
>>

>
>
> sending to informix-list
>
>

--


Atte,


Jesús Antonio Santos Giraldo
[email]jeansagi@myrealbox.com[/email]
[email]jeansagi@netscape.net[/email]

sending to informix-list