Test the DB2 temporary table in the SQL process and SQL statement (1)

This article will test for you how to create temporary tables in the SQL process and SQL statements respectively in the DB2 database, and what are the similarities and differences between the execution results after inserting data, for your reference, I hope to enlighten you.
 
Purpose:
 
Create a temporary table in the SQL process and SQL statement, and insert data to see the similarities and differences between the execution results.
 
Test environment:
 
DB2 UDB V9.1
 
Run the SQL statement in the attachment to obtain a table.

Test code and running result:
 
I. Temporary
Test Summary of the DB2 temporary table in the SQL process and SQL statement
 
Purpose:
 
Create a temporary table in the SQL process and SQL statement, and insert data to see the similarities and differences between the execution results.
 
Test environment:
 
DB2 UDB V9.1
 
Run the SQL statement in the attachment to obtain a table.