You can create triggers for CGTT.
您可以为CGTT创建触发器。
CGTT does not support constraints.
CGTT不支持约束。
The syntax for CGTT is very similar to DGTT.
CGTT的语法与DGTT 极为相似。
Listing 1 shows the SQL sytax for creating CGTT
清单1展示了创建CGTT 的语法
You are able to disable compression of CGTT tables.
您可以禁用压缩cgtt表。
Roll back conditions (CGTT allows flexibility for this).
回滚条件(CGTT具有这方面的灵活性)。
Compared to CGTT, DGTT has the following limitations.
与CGTT相比，DGTT具有以下限制。
There are two major motivations for the creation of CGTT.
创建CGTT主要有两个动机。
Tuning can be made easier with the CGTT support of indexes.
CGTT在支持索引后也简化了调优工作。
Listing 12 shows how the DGTT table can be converted to CGTT.
清单12展示了如何将dgtt表转换为CGTT。
CGTT essentially moves the table setup process outside the session.
从本质上说，CGTT将表设置流程移到了会话外部。
Once they commit their selections, they are moved from the CGTT to the real tables.
提交选择之后，它们才从CGTT移动到实际表中。
Once CGTT table cgttbase1 is created, it is persistent to all sessions that follow.
创建cgtt表cgttbase1之后，它将持久化到后续所有的会话中。
CGTT tables can be defined up front, and users can use them much like regular tables.
可以提前定义cgtt表，并且用户可以像普通表一样使用它。
So once a CGTT is created, it can be used by any session without having to create it again.
因此，一旦创建了一个CGTT，它可由任何会话使用，没有必要再次创建它。
Convert a declared global temporary table (DGTT) to a created global temporary table (CGTT).
将已声明的全局临时表(DGTT)转换为已创建的全局临时表(CGTT)。
The content of the CGTT is local to the session. You should use CGTTs instead of DGTTs when.
CGTT的内容仅供会话使用。
Each connection using the CGTT has its own copy of the CGTT and only sees the data in its copy.
使用CGTT的每个连接拥有自己的CGTT拷贝，而且只能看到自己拷贝中的数据。
If indexes are created on the CGTT table, the query compiler will take those indexes into account.
如果为cgtt表创建了索引，则查询编译器会将这些索引考虑在内。
First, CGTT behaves more like a regular table for SQL programmers, but with the potential of a performance advantage.
首先，CGTT的行为对SQL程序员而言更像是一个普通表，但它具有提升性能的潜力。
Use a created global temporary table (CGTT) for per-session storage of the baseline data (use one CGTT per table function).
使用为基线数据的每会话存储创建的全局临时表（CGTT）（对于每个表函数，使用一个 CGTT）。
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临时表。
The definition of a CGTT is stored in the catalogs like a regular table, and the CGTT is instantiated on the first use by a connection.
CGTT的定义像常规表一样存储在编目中，当一个连接第一次使用CGTT时对它进行实例化。
If you create a CGTT table using the like clause (create CGTT like a regular table), the statement will be successful, but the CGTT will not inherit the constraints of the original table.
如果您使用like语句创建cgtt表(像普通表一样创建CGTT)，则该语句会执行成功，但CGTT不会继承原始表的约束。
If you create a CGTT table using the like clause (create CGTT like a regular table), the statement will be successful, but the CGTT will not inherit the constraints of the original table.
如果您使用like语句创建cgtt表(像普通表一样创建CGTT)，则该语句会执行成功，但CGTT不会继承原始表的约束。
应用推荐