Creating created global temporary tables

Use the Data Project Explorer to create global temporary tables to store data temporarily.

Procedure

You can create global temporary tables by using the Data Project Explorer or the Data Source Explorer:

In the Data Project Explorer, right-click a schema and select Add Data Object > Created Global Temporary Table. The temporary table is created under the schema.

Results

The temporary table is created in the location that you specify.

What to do next

For DB2® for Linux, UNIX, and Windows data models, you can modify the table to specify whether data is preserved or deleted when changes are committed, or when logging is turned off. You can view the global temporary tables in the Data Source Explorer view.

Feedback