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?

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/