creating global temporary tables

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rishi - 31 Oct 2005 08:25 GMT

Can you please advice on how to create global temporary tables in
informix 9.1, so that it can be accessed across procedures?

Reply to this Message

Jonathan Leffler - 31 Oct 2005 09:43 GMT

> Can you please advice on how to create global temporary tables in
> informix 9.1, so that it can be accessed across procedures?

You should have abandoned IDS 9.1x prior to 2000-01-01.

What do you mean by 'across procedures'?

Did you read the SQL manual on CREATE TABLE - the section on CREATE TEMP
TABLE?

The name 'global temporary table' is SQL standard speak and doesn't have
a direct counter-part in IDS. IDS temporary tables have to be created
in each session that needs them, but they are global in each session.

Signature

Jonathan Leffler #include <disclaimer.h>
Email: jleffler@earthlink.net, jleffler@us.ibm.com
Guardian of DBD::Informix v2005.02 -- http://dbi.perl.org/

Reply to this Message

Superboer - 31 Oct 2005 10:19 GMT

may be you want to have a look at
create raw table myraw ( a int )
so raw tables; they are not logged. check the manual for it.
it may do what you require.

Superboer.

Jonathan Leffler schreef:

> > Can you please advice on how to create global temporary tables in
> > informix 9.1, so that it can be accessed across procedures?
[quoted text clipped - 14 lines]
> Email: jleffler@earthlink.net, jleffler@us.ibm.com
> Guardian of DBD::Informix v2005.02 -- http://dbi.perl.org/

Reply to this Message

Dirk Moolman - 31 Oct 2005 14:31 GMT

-----Original Message-----
From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org]
On Behalf Of Rishi
Sent: 31 October 2005 09:25 AM
To: informix-list@iiug.org
Subject: creating global temporary tables

>Can you please advice on how to create global temporary tables in
>informix 9.1, so that it can be accessed across procedures?

I think what (Rishi?) is looking for, it a temp table that can be
accessed by other users (other sessions) - am I correct in this
assumption ?

This is not possible in Informix, unless IDS 10 has a new feature I am
not aware of.

Dirk
sending to informix-list

Reply to this Message