Are user-defined temp tables permanently stored in the temp tablespace?
Following is taken from the Quest SQL Optimizer for DB2 Help file.
Temporary tables only exist in your current session. In order to optimize a SQL statement that uses temporary tables, these tables need to be created in this session before you optimize. The User-Defined Temp Table window allows the creation of temporary tables to be use throughout modules that use the original sessions that is created as you logon.
Temporary tables created in the User-Defined Temp Table module are used in the SQL Optimizer, Index Expert, and SQL Scanner. They also can be viewed in the Database Explorer.
Temporary tables are dropped when you:
- Exit from the program
- Reconnect with the same or a different user logon
- Drop it using the User-Defined Temp Table module