Re: create temp table with no log

Posted in 2003

John_Thomas@ao.uscourts.gov — Tue, 8 Jul 2003 11:04:24 -0400 — source: Usenet: comp.databases.informix

This is a multipart message in MIME format. --=_alternative 0052E21185256D5D_= Content-Type: text/plain; charset="us-ascii" You need a column list just like any other table. create temp table tempdog ( col1 char (1), col2 char(1) ) with no log; --John 202-502-2599 (or x 2599) "cathy wang" <cathyyanwang@hotmail.com> Sent by: owner-informix-list@iiug.org 07/08/2003 10:46 AM To: ids@iiug.org, informix-list@iiug.org cc: Subject: create temp table with no log Hello, I am trying to create a temp table with no log. Could someone help me with the syntax ? I tried: create temp table tempdog no log; create temp table tempdog with no log; create temp table tempdog no logging; none of the above works. Thanks ! Cathy MSN 8 with e-mail virus protection service: 2 months FREE* sending to informix-list --=_alternative 0052E21185256D5D_= Content-Type: text/html; charset="us-ascii" You need a column list just like any other table. create temp table tempdog ( col1 char (1), col2 char(1) ) with no log; --John 202-502-2599 (or x 2599) <table width=100%> <tr valign=top> <td> <td>"cathy wang" <cathyyanwang@hotmail.com> Sent by: owner-informix-list@iiug.org 07/08/2003 10:46 AM <td>                To:        ids@iiug.org, informix-list@iiug.org         cc:                 Subject:        create temp table with no log</table> Hello,   I am trying to create a temp table with no log.  Could someone help me with the syntax ?   I tried:   create temp table tempdog no log; create temp table tempdog with no log; create temp table tempdog no logging;   none of the above works.   Thanks ! Cathy <hr>MSN 8 with <a href="http://g.msn.com/8HMEENUS/2740??PS=">e-mail virus protection service: </a>2 months FREE* sending to informix-list --=_alternative 0052E21185256D5D_=-- sending to informix-list