Temporary Tables in Db2 (along with a painful lesson)


A temporary table (in most RDMS) is a place to keep data for the duration of some application process.  The data is basically private and only available to the application user.

The typical end-user of a temporary table ranges from simple ad-hoc dynamic end-users (like you or me) up to real application programs (native SQL stored procedures or COBOL). 

Temporary tables are used in dynamic and static SQL. 

A temporary table is a place to store relevant to your needs.  Whether you are an application or some end-user. It is a place to keep data. It helps give SQL coding options. They can help reduce SQL complexity!  You can break down potentially complex, confusing or large SQL into smaller SQL chunks via temporary tables.

Click here to read the full article. (IDUG login required):
https://www.idug.org/p/bl/ar/blogaid=843

 

1 Like
Recent Stories
Advanced JSON Understanding how to Exploit Db2 Capabilities in the NoSQL World by George Baklarz

IBM Db2 Editions Simplified for Straightforward Deployment Options

Db2 Architecture Overview and BLU