The duration of a temporary table depends on whether or not it is logged.
A logged temporary table exists until one of the following situations occurs:
When any of these events occur, the temporary table is deleted.
Nonlogging temporary tables include tables that were created using the WITH NO LOG option of CREATE TEMP TABLE and all SCRATCH tables.
A nonlogging temporary table exists until one of the following events occurs:
Because these tables do not disappear when the database is closed, you can use a nonlogging temporary table to transfer data from one database to another while the application remains connected.
Related statements: ALTER TABLE, CREATE TABLE , CREATE DATABASE, DROP TABLE , and SELECT
If you use Extended Parallel Server, see also SET Default Table Type and SET Default Table Space .
For additional information about the DBANSIWARN and DBSPACETEMP environment variables, refer to the IBM Informix Guide to SQL: Reference.
For additional information about the ONCONFIG parameter DBSPACETEMP, see your IBM Informix Administrator's Guide.