No user temporary table space was created.
没有创建用户临时表空间。
This will populate the temporary table with three rows.
向临时表填充三行记录。
Listing 9 shows an example of a declared temporary table.
清单9展示了一个已声明临时表的示例。
Consider using a table variable instead a temporary table.
考虑使用表变量来代替临时表。
Temporary tables are stored in user temporary table Spaces.
临时表存储在用户临时表空间中。
No user temporary table Spaces exist when a database is created.
创建数据库时不存在用户临时表空间。
The consumed space in the user temporary table space will be freed.
所消耗的用户临时表空间中的空间将得到释放。
Then a procedure p1 was created which references the temporary table.
然后创建了引用临时表的过程p1。
User temporary table Spaces are optional and none are created by default.
用户临时表空间是可选的，默认情况下不会创建用户临时表空间。
Indexes defined on a declared global temporary table cannot be transferred.
定义在声明的全局临时表上的索引不能被转移。
Using a procedure to initialize the temporary table yields three key benefits.
使用过程来初始化临时表可带来三个主要优点。
To use this routine in DB2 V8.2.2 requires an 8 KB page user temporary table space.
为了使用该例程，DB 2V8.2.2中需要一个8KB页面的用户临时表空间。
As well, DB2 always required a system temporary table space that had a 4 KB page size too.
DB 2同样总是需要一个也是4KB页面大小的系统临时表空间。
You can reference a created temporary table in SQL functions, triggers, indexes, and views.
您可以在sql函数、触发器、索引和视图中引用已创建的临时表。
The usage of a temporary table limits tracing to procedures of the class MODIFIES SQL DATA.
临时表的使用限制了对属于MODIFIESSQLdata类别的过程的跟踪。
It completes the encapsulation of the temporary table declaration through stored procedures.
完成了通过存储过程声明临时表的封装。
If the sorted information requires a temporary table to be returned, it is a non-piped sort.
如果排序信息的返回需要临时表，那它就是非管道排序（non-pipedsort）。
Convert a declared global temporary table (DGTT) to a created global temporary table (CGTT).
将已声明的全局临时表(DGTT)转换为已创建的全局临时表(CGTT)。
Finally, you used a temporary table to modify the structure of an existing database table.
最后，使用临时表来修改现有数据表的结果。
You should create one or more USER temporary table spaces for storing data of temporary tables.
您应当创建一个或多个USER临时表空间来存储临时表的数据。
How can P2 and P3 reference a temporary table declared in P1 without re-declaring it themselves?
P2和P3又如何能引用P 1中声明的临时表而无需再重新声明呢？
User temporary table spaces: User temporary table spaces store declared global temporary tables.
用户临时表空间： 用户临时表空间存储已声明的全局临时表。
The process of dropping a table is demonstrated on a newly created temporary table in Listing 4.
清单4中在新创建的临时表上演示了删除表的过程。
We then turn tracing on using the default user temporary table space provided by the friendly DBA.
然后，我们使用友好的DBA提供的默认用户临时表空间打开跟踪。
Step3: Create the procedure count_rows which returns the number of rows found in the temporary table.
步骤3：创建count_rows过程，返回在临时表中找到的行数。
The defragmenter may not be run on the partition partition, secondary server, or a temporary table.
碎片整理程序不能在已分区分区、备份服务器、或者临时表上运行。
Prior to this release, the declared temporary table (DGTT) was the only type of user-defined temporary table.
在此发行版之前，已声明的临时表(DGTT)是唯一的一种用户定义的临时表。
At least one user temporary table space should be created to allow the definition of declared temporary tables.
至少应当创建一个用户临时表空间以允许定义已声明的临时表。
If you do need to modify the structure of a table, you need to use a temporary table, as shown in Listing 6.
如果不需要修改表的结构，则需要使用临时表，如清单6所示。
应用推荐