Re: Temp tables - Where are they

"Surfer!" wrote: > > 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'! All together now..... "Oh yes they will!" ;-) They will inherit the logging mode of the database they are created in, unless the WITH NO LOG clause is used. Thus for logged databases they cannot be created in the TEMP dbspaces, which will be wasted. > And sysmaster only exists in Online/IDS databases.... And so do TEMP dbspaces. ;-) > If he doesn't have a TEMP DBSPACE he needs one - fast! More than one would be ideal. No good having just one IMNSHO. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@mydas.freeserve.co.uk |//////// /| | http://www.informix.com http://www.informixhandbook.com |///// / //| | http://www.iiug.org +-----------------------------------+//// / ///| | |What year 2000 bug? year 2000 bug? |/// / ////| | |year 2000 bug? year 2000 bug? year |// / /////| | |2000 bug? year 2000 bug? year 1900 |/ ////////| +----------------------+-----------------------------------+-----------+