例1：创建引用临时表的过程。
Example 1: Building a procedure which references a temporary table.
使用过程来删除临时表有以下两个优点
Using a procedure to drop the temporary table has these two benefits
创建一个用作全局临时表的用户表空间。
Create a user temporary table space for use by the global temporary table.
运行close_temp删除临时表。
——临时表空间，tempspace1。
临时表空间可以是系统的，也可以是用户的。
最好从系统临时表空间创建用户临时表空间。
It is best to create user temporary table space from the system one.
例如，临时表包含一列即位置。
For instance, temporary table contains one column namely Location.
不通过临时表而直接加载目标。
应用程序将继续消费越来越多的用户临时表空间。
The application will keep on consuming more and more user temporary table space.
表变量、会话与临时表。
每个数据库必须至少有一个系统临时表空间。
毕竟，您可以相当容易地重新构建临时表的内容。
After all, the content of the temp can be reconstructed easily enough.
在所述第一部分已完成-临时表可以被丢弃。
Once the first part is completed - the temp table can be discarded.
对于临时表处于表缓冲方式下的表，不能发布此命令。
Command cannot be issued on a table with cursors in table buffering mode.
请注意insert _to _ temp不需要再声明临时表了。
Note that insert_to_temp does not need to declare the temp table.
要想成功地运行mondelta .db 2脚本，必须定义一个用户临时表空间。
You must define a user temporary table space in order to successfully run the mondelta.db2 script.
步骤2：在DevelopmentCenter中，创建过程close_temp来删除临时表session . temp。
Step 2: In Development Center, create the procedure close_temp which drops the temporary table session.temp.
否则，处理器必须先使用临时工作表对记录进行排序。
Otherwise, the processor has to use a temporary work table to sort the records first.
一个临时的解决方法是优化数据库表(就像以前做的)。
A short term fix (as has been done before), is to optimize the database tables.
存储可以很容易删除的临时数据，只需删除表即可删除这些数据。
Store data that is short-lived and could be easily deleted by simply deleting the table.
临时程序表t PT ？
临时程序表t PT ？
应用推荐