Re: Temporary table
roeferr@ig.com.br (Ferronato) wrote in message news:<df1bdeb4.0312240634.7b2ae02e@posting.google.com>...
> 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?
OK while we are on the subject, how do you know if it is your temp
table and not some other sessions temp table. I can see a temp table
list in onstat -g ses and I know only your session can access your
temp table, but I don't know where to find the temp tables that are
only valid for your session. The application could of course tag them
with your session id as in temp_table_1_for_session_1234 etc. but is
there a table that can give you the session and temp table info.