No user temporary table space was created.
没有创建用户临时表空间。
Run close_temp to drop the temporary table.
运行close_temp删除临时表。
Temporary table space can be either system or user.
临时表空间可以是系统的,也可以是用户的。
This will populate the temporary table with three rows.
向临时表填充三行记录。
SQLT0001.0 - The temporary table space, tempspace1.
——临时表空间,tempspace1。
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.
所消耗的用户临时表空间中的空间将得到释放。
It is best to create user temporary table space from the system one.
最好从系统临时表空间创建用户临时表空间。
Then a procedure p1 was created which references the temporary table.
然后创建了引用临时表的过程p1。
Example 1: Building a procedure which references a temporary table.
例1:创建引用临时表的过程。
Using a procedure to drop the temporary table has these two benefits
使用过程来删除临时表有以下两个优点
User temporary table Spaces are optional and none are created by default.
用户临时表空间是可选的,默认情况下不会创建用户临时表空间。
Create a user temporary table space for use by the global temporary table.
创建一个用作全局临时表的用户表空间。
Indexes defined on a declared global temporary table cannot be transferred.
定义在声明的全局临时表上的索引不能被转移。
Using a procedure to initialize the temporary table yields three key benefits.
使用过程来初始化临时表可带来三个主要优点。
The application will keep on consuming more and more user temporary table space.
应用程序将继续消费越来越多的用户临时表空间。
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.
完成了通过存储过程声明临时表的封装。
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中在新创建的临时表上演示了删除表的过程。
应用推荐