Create temporary table DB2 supports created global temporary tables in addition to declared global temporary tables.
CREATE TEMPORARY TABLE除了声明全局临时表之外，DB 2还支持创建全局临时表。
Then for that database, a user can be granted the CREATE TEMPORARY TABLES privilege, along with any other privileges required for temporary table operations done by that user.
然后对于该数据库，可以向用户授予CREATE TEMPORARY TABLES权限以及该用户执行的临时表操作所需的任何其他权限。
You should create one or more USER temporary table spaces for storing data of temporary tables.
您应当创建一个或多个USER临时表空间来存储临时表的数据。
The script below shows an example, which you can modify to create a user temporary table space in your environment.
下面的脚本给出了一个例子，我们可以对其进行更改，从而在自己的环境中创建一个用户临时表空间。
Table Spaces that you create in DSNDB07 will be used as storage for processing SQL joins and sorts as well as for temporary tables.
您在DSNDB07创建的表空间将用作处理SQL联接和排序以及临时表的存储。
Listing 2 creates a public alias for the newly create global temporary table so that it can be referred to as gtt_test without having to qualify the table name.
清单2将为新创建的全局临时表创建一个公有别名，以便于可以使用gtt _ test来引用它，而不需要限定表名。
Step 1: In Development Center, create a procedure called init_temp() to encapsulate the declaration of the temporary table session.temp.
步骤1：在DevelopmentCenter 中，创建名为 init_temp()的过程来封装临时表session.temp 的声明。
Step3: Create the procedure count_rows which returns the number of rows found in the temporary table.
步骤3：创建count_rows过程，返回在临时表中找到的行数。
Recall that in order to use temporary tables, a user temporary table space must exist in the database (none exists by default). Here's how you would create such a table space.
我们记得为了要使用临时表，数据库中必须存在一个用户临时表空间(默认情况下没有)。
Recall that in order to use temporary tables, a user temporary table space must exist in the database (none exists by default). Here's how you would create such a table space.
我们记得为了要使用临时表，数据库中必须存在一个用户临时表空间(默认情况下没有)。
应用推荐