Re: Making a temp table permanent

William Hayman wrote: > > Hi > > We are using > > select ... > into temp table_name> > What we wish to do is make the temp table permanent? > > Thanks > > William Try: create perm_table ... insert into perm_table select ... You can't directly change an existing temp table to permanent. You can do the above, selecting from the temp table, then drop the temp table and rename the permanent table to the name the temp table had. Best wishes, ---------------------------------------------------------------------- John H. Frantz Power-4gl: Extending Informix-4gl frantz@centrum.is http://www.rl.is/~john/pow4gl.html