Re: Making a temp table permanent

On 27 Jan 1998 09:28:16 -0500, in article <6akqu0$aib@cssun.mathcs.emory.edu>, pschaefl@sidley.com ("Schaeflein, Paul") wrote: : :The practice in my shop is to explicitly create temp tables. Then, for :debugging, a simple change can be made: : :CREATE TEMP TABLE tempname :#CREATE TABLE tempname : (field 1 char(10), : etc. : : :Hi : :We are using : :select ... :into temp table_name : :What we wish to do is make the temp table permanent? You need to make the table in advance of the select and do your select differently... create table table_name .... insert into table_name select ..... -- gburnore@netcom dot com or gburnore@netcom databasix com --------------------------------------------------------------------------- How you look depends on where you go. --------------------------------------------------------------------------- Gary L. Burnore | '۳'''''''ۺ''''''''''۳ | '۳'''''''ۺ''''''''''۳ DOH! | '۳'''''''ۺ''''''''''۳ | '۳ 3 4 1 4 2 '' 6 9 0 6 9 '۳ spamgard(tm): zamboni | Official Proof of Purchase =========================================================================== PGPprint: C63B CF4E 1B71 4D7E C6F8 AF4E 338D 5CB4 KeyID: 0x0F7EDBD9 (RSA) finger gburnore@netcom.com for public key ---------------------------------------------------------------------------