Re: Temporary table

On Fri, 16 Jan 2004 15:44:21 -0500, Curtis Crowson wrote: > roeferr@ig.com.br (Ferronato) wrote in message > news:<df1bdeb4.0312240634.7b2ae02e@posting.google.com>... <SNIP> >> > 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. There are several scripts for this in the IIUG Repository. Art S. Kagel

"Art S. Kagel" <kagel@bloomberg.net> wrote in message news:pan.2004.01.21.11.51.04.83011.12806@bloomberg.net... > On Fri, 16 Jan 2004 15:44:21 -0500, Curtis Crowson wrote: > > > roeferr@ig.com.br (Ferronato) wrote in message > > news:<df1bdeb4.0312240634.7b2ae02e@posting.google.com>... > <SNIP> > >> > 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. > > There are several scripts for this in the IIUG Repository. There isn't a single script which ties a temp table to a session. Rajib Sarkar has a script on korn shell/awk etc, but it doesn't work, at least for me. I have tried this in every possible way, but it looks like that thru sysmaster it is impossible to link a temp table to a session. Ravi