CREATE TEMPORARY TABLES, LOCK TABLES.
创建临时表，锁表。
In Step 4, we doubled SORTHEAP to 2048 to avoid sort overflows because some queries needed to create temporary tables.
在步骤4中，我们使SORTHEAP加倍到2048以避免排序溢出，因为某些查询需要创建临时表。
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临时表空间来存储临时表的数据。
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联接和排序以及临时表的存储。
Now that we have established this interesting ability to create procedures which utilize temporary tables, we now demonstrate how temporary tables and their data can be.
既然我们已经利用有趣的方法创建了使用临时表的过程，接下来就演示临时表及其数据如何可以？
Create temporary table DB2 supports created global temporary tables in addition to declared global temporary tables.
CREATE TEMPORARYTABLE除了声明全局临时表之外，DB 2还支持创建全局临时表。
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.
我们记得为了要使用临时表，数据库中必须存在一个用户临时表空间(默认情况下没有)。
One implication of this behavior is that a session can manipulate its temporary tables even if the current user has no privilege to create them.
这种行为的一个影响是，即使当前用户没有创建它们的权限，会话也可以操纵它的临时表。
To keep privileges for temporary and nontemporary tables separate, a common workaround for this situation is to create a database dedicated to the use of temporary tables.
为了保持临时表和非临时表的权限分开，这种情况的常见解决方法是创建专用于临时表的数据库。
To keep privileges for temporary and nontemporary tables separate, a common workaround for this situation is to create a database dedicated to the use of temporary tables.
为了保持临时表和非临时表的权限分开，这种情况的常见解决方法是创建专用于临时表的数据库。
应用推荐