CREATE TEMPORARY TABLES, LOCK TABLES.
创建临时表，锁表。
Tempspace1 - Stores system temporary tables.
Tempspace1——存储系统临时表。
RUNSTATS on declared global temporary tables.
已声明的全局临时表上的runstats。
Extended indexes or declared temporary tables.
扩展的索引或声明的临时表。
Temporary tables are stored in user temporary table Spaces.
临时表存储在用户临时表空间中。
Use temporary tables and table variables appropriately.
适当的使用临时表和表变量。
Temporary - to store the system temporary tables created during database processing.
Temporary——存储数据库处理过程中所创建的系统临时表。
You should create one or more USER temporary table spaces for storing data of temporary tables.
您应当创建一个或多个USER临时表空间来存储临时表的数据。
User temporary table spaces: User temporary table spaces store declared global temporary tables.
用户临时表空间： 用户临时表空间存储已声明的全局临时表。
You can even use temporary tables from the DB2 Command Line Processor (CLP), as you will soon see.
下面很快就能看到，您甚至可以通过DB 2命令行处理器(CLP)使用临时表。
This section discusses the behaviors of created temporary tables that should be taken into account.
本节讨论应该考虑的已创建的临时表的行为。
SET options, it is in a separate transaction, it does not see your temporary tables, and so on.
SET选项，位于不同的事务中，并且看不到您的临时表等。
Note: In contrast, DB2 has implemented declared global temporary tables as transactional state objects.
注意：和事务性状态对象一样，DB2 实现了声明式的全局临时表。
Temp dbspace: a temporary dbspace is a dbspace reserved exclusively for the storage of temporary tables.
临时dbspace：临时dbspace是专门为存储临时表保留的dbspace。
At least one user temporary table space should be created to allow the definition of declared temporary tables.
至少应当创建一个用户临时表空间以允许定义已声明的临时表。
Created global temporary tables (CGTTs) are a new feature in DB2 9.7 that provide the following new capabilities.
已创建的全局临时表(CGTT)是DB 2 9.7中的新特性，它提供了以下功能。
Create temporary table DB2 supports created global temporary tables in addition to declared global temporary tables.
CREATETEMPORARYTABLE除了声明全局临时表之外，DB 2还支持创建全局临时表。
These statistics are stored in memory structures that represent the catalog information for declared temporary tables.
这些统计信息存储在表示声明的临时表的目录信息的内存结构中。
In Step 4, we doubled SORTHEAP to 2048 to avoid sort overflows because some queries needed to create temporary tables.
在步骤4中，我们使SORTHEAP加倍到2048以避免排序溢出，因为某些查询需要创建临时表。
Temporary dbspaces: : a temporary dbspace is a regular dbspace, used by the database server to store temporary tables.
临时dbspace：临时dbspace属于常规dbspace，数据库服务器在存储临时表时将使用到它。
The second motivation for the CGTT offering is to assist the translations of non-DB2 temporary tables to DB2 temporary tables.
提供CGTT的第二个动机是帮助将非db2临时表转换为DB 2临时表。
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联接和排序以及临时表的存储。
Under certain conditions, internal temporary tables are created during the execution of the merge statement, as shown in Listing 7.
在某些条件下，会在merge语句执行过程中创建内部临时表，如清单7所示。
SQL Azure is based on the relational database model, complete with constraints, transactions, temporary tables, and stored procedures.
SQLAzure的基础是关系数据库模型、提供了对约束、事务、临时表以及存储过程的完整支持。
DB2 9.7 compresses more than just row data; it can also compress indexes, log files, temporary tables, inline XML data, and large objects.
DB 2 9.7不仅压缩行数据；它还可以压缩索引、日志文件、临时表、内联xML数据和大对象。
A general extension to global temporary tables, which allows temporary tables that are not logged to be completely taken out of transaction control.
对全局临时表的一个通用扩展，允许没有日志记录的临时表完全脱离事务控制。
Although temporary tables are most often used in SQL procedures, they can also be created by any application which can establish a connection to DB2.
虽然临时表总是用于SQL过程中，但也能被任何可连接db2的应用程序创建。
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.
这种行为的一个影响是，即使当前用户没有创建它们的权限，会话也可以操纵它的临时表。
Sorry, I have just the temporary tables and table official made a mistake, the two paper is different, please sign them again names, very hold …
怎么用英文说：对不起，刚才我把临时的表格和正式的表格弄错…
Sorry, I have just the temporary tables and table official made a mistake, the two paper is different, please sign them again names, very hold …
怎么用英文说：对不起，刚才我把临时的表格和正式的表格弄错…
应用推荐