Re: create temp table with no log
<html><div style='background-color:'><DIV> <P>Mark,</P> <P>Thanks a lot !</P> <P>Regards,</P> <P>Cathy<BR><BR></P></DIV> <DIV></DIV>>From: "Mark Denham" <MKDENHAM@COMCAST.NET> <DIV></DIV>>Reply-To: "Mark Denham" <MARK@VUNTEC.COM> <DIV></DIV>>To: "cathy wang" <CATHYYANWANG@HOTMAIL.COM>,<IDS@IIUG.ORG>,<INFORMIX-LIST@IIUG.ORG> <DIV></DIV>>Subject: Re: create temp table with no log <DIV></DIV>>Date: Tue, 8 Jul 2003 11:17:40 -0400 <DIV></DIV>> <DIV></DIV>>You need to use the following syntax: <DIV></DIV>> <DIV></DIV>>create temp table mytemp (a integer, b char(5)) with no log; <DIV></DIV>> <DIV></DIV>>All the column names and types MUST be specified in this format of the command. The alternative is to select the data you want into a temp table: <DIV></DIV>> <DIV></DIV>>select [*|colA,colB,colC...] <DIV></DIV>>from mytable <DIV></DIV>>into temp mytemp with no log; <DIV></DIV>> <DIV></DIV>>In this latter form if any of the columns are agregates [such as sum] you will need to give the column a name ie: <DIV></DIV>> <DIV></DIV>>select sum(weekly_pay) as annual_sal <DIV></DIV>>from .... <DIV></DIV>>into temp.... <DIV></DIV>> <DIV></DIV>>If you do not specify a name you will get an error. <DIV></DIV>> <DIV></DIV>>Mark <DIV></DIV>> ----- Original Message ----- <DIV></DIV>> From: cathy wang <DIV></DIV>> To: ids@iiug.org ; informix-list@iiug.org <DIV></DIV>> Sent: Tuesday, July 08, 2003 10:46 <DIV></DIV>> Subject: create temp table with no log <DIV></DIV>> <DIV></DIV>> <DIV></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>> <DIV></DIV>> <DIV></DIV>>------------------------------------------------------------------------------ <DIV></DIV>> MSN 8 with e-mail virus protection service: 2 months FREE* sending to informix-list <DIV></DIV></div><br clear=all><hr>MSN 8 helps <a href="http://g.msn.com/8HMDENUS/2743??PS=">ELIMINATE E-MAIL VIRUSES. </a> Get 2 months FREE*.</html> sending to informix-list