Re: [Q] Another SQL question???

Posted in 1995

Guenther Koegebehn — Wed, 15 Nov 1995 05:15:47 GMT — source: Informix-list mailing list archive (1991-1998)

rob@dssmktg.com (Robert Minter) wrote: >Ed Schaefer writes: >* you must be using the standard engine. We have had probelms dropping >* temp tables with standard engine so we have taken to deleting all the >* rows from the temp table instead of re-creating it. Now, with the >* online engine you don't have a problem dropping temp tables. >Unless you are using Online 5.01. >We've had no problems using SE for temp tables. When we used SE 4.xx we could drop temp tables. Since we use SE 5.xx we had to make a delete where 1=1, since temp tables could no longer be dropped. Guenther Koegebehn 100662.1447@compuserve.com