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

Rishi wrote:
> 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.

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

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:

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