Re: create temp table with no log
On Tue, 08 Jul 2003 10:46:19 -0400, cathy wang wrote:
PLEASE DO NOT POST HTML it more than doubles the required bandwidth and
most of use use newsreaders that do not understand HTML or MIME (which is
worse).
You have to define a column list for the temp table just like any other:
create temp table fred (one int, two char(20)) with no log;
Art S. Kagel
> <html><div style='background-color:'><DIV>Hello,</DIV> <DIV> </DIV>
> <DIV>I am trying to create a temp table with no log. Could someone
> help me with the syntax ?</DIV> <DIV> </DIV> <DIV>I tried:</DIV>
> <DIV> </DIV>
> <DIV>create temp table tempdog no log;</DIV> <DIV>create temp table
> tempdog with no log;</DIV> <DIV>create temp table tempdog no
> logging;</DIV> <DIV> </DIV>
> <DIV>none of the above works.</DIV>
> <DIV> </DIV>
> <DIV>Thanks !</DIV>
> <DIV>Cathy</DIV></div><br clear=all><hr>MSN 8 with <a
> href="http://g.msn.com/8HMEENUS/2740??PS=">e-mail virus protection
> service: </a> 2 months FREE*</html> sending to informix-list