Re: Temporary table
TRY IT:
In a database:
----------------------- spa@dsa2 --------------- Press CTRL-W for Help
--------
create temp table rfo (a int) with no log ;
insert into rfo values (100) ;
NOW, IN OTHER SESSION, IN THE SAME DATABASE OR IN OTHER DATABASE IF IN
THE SAME INSTANCE :
----------------------- dbprod@dsa2 ------------ Press CTRL-W for Help
--------
select * from sysmaster:systabnames
where dbsname = 'spa'
and tabname = 'rfo'
THE RESULT WILL BE:
----------------------- dbprod@dsa2 ------------ Press CTRL-W for Help
--------
partnum 24117537
dbsname spa
owner informix
tabname rfo
collate en_US.819
Best regards, merry christmas ! RFo
"Sauron" <sauron_news@ukr.net> wrote in message news:<br4970$v2k$1@news.kiev.sovam.com>...
> Hi!
>
> How can I define if defined temp table exists in the current session?