User-Defined Temp Tables Tutorial
When your SQL statement uses a temporary table, you must create a temporary table before you use the SQL statement in several modules. When you exit from the program or connect to another session, all the temporary tables you created are dropped.
Create Temporary Tables
-
Click
.
-
On the Creation tab, type in the statements for creating the temp table. You may include CREATE, SELECT INTO, INSERT, UPDATE and DELETE statements.
-
Click Execute.