Temp tables - Where are they

Hello all, Please see the below part of the output of "onstat -g ses <session id>" ---------------------------------------------------- Id Stmt type Database Lvl Mode ERR ERR Vers 45 - stores7 NL Not Wait 0 0 7.30 Last parsed SQL statement : select * from customer into temp temp1 User-created Temp tables : partnum tabname rowsize 1000ab temp1 134 ----------------------------------------------------- Where is the table with patnum 1000ab created ? I could not find a entry for it in "systables" or in the output of "onstat -t". From which sysmaster table can I get the entry for these temp tables. Thank you in advance Regards alex __________________________________________________ Do You Yahoo!? Talk to your friends online with Yahoo! Messenger. http://im.yahoo.com

M G wrote: > select * from customer into temp temp1> I could not find a entry for it in "systables" Try "SELECT * FROM sysmaster:systabnames WHERE tabname = 'temp1'". BTW "select * from customer into temp temp1 WITH NO LOG" will be faster (if Your database has transaction logging). > alex Leonid.

In article <38B251DD.9BEB35D0@dati.lv>, Leonids.Voroncovs@dati.lv writes >M G wrote: > >> select * from customer into temp temp1>> I could not find a entry for it in "systables" > >Try "SELECT * FROM sysmaster:systabnames WHERE tabname = 'temp1'". >BTW "select * from customer into temp temp1 WITH NO LOG" >will be faster (if Your database has transaction logging). If he is using Online/IDS with a TEMP DBSPACE they won't get logged even without 'WITH NO LOG'! And sysmaster only exists in Online/IDS databases.... If he doesn't have a TEMP DBSPACE he needs one - fast! > >> alex > >Leonid. > > -- Surfer!