INTO TEMP Clause

The INTO TEMP clause creates a temporary table to hold the query results. The default initial and next extents for a temporary table are four pages. The temporary table must be accessible by the built-in RSAM access method of the database server; you cannot specify another access method.

If you use the same query results more than once, using a temporary table saves time. In addition, using an INTO TEMP clause often gives you clearer and more understandable SELECT statements.

Data values in a temporary table are static; they are not updated as changes are made to the tables that were used to build the temporary table. You can use the CREATE INDEX statement to create indexes on a temporary table.

A logged, temporary table exists until one of the following situations occurs:

• The application disconnects from the database.
• A DROP TABLE statement is issued on the temporary table.
• The database is closed.

For Dynamic Server, if your database does not have transaction logging, the temporary table behaves in the same way as a table created with the WITH NO LOG option.

3If you specify more than one temporary dbspace in the DBSPACETEMP environment variable (or if this is not set, 3in the DBSPACETEMP configuration parameter), the INTO TEMP clause loads the 3rows of the results set of the query into each of these dbspaces in round-robin 3fashion. For more information about the storage location of temporary tables 3that queries with the INTO TEMP clause create, see Where Temporary Tables are Stored.