After being created, the MQT is in check pending state (see Demystifying table and table space states), and cannot be queried until the SET INTEGRITY statement has been executed against it.
MQT被创建之后,便处于检查暂挂状态(请参阅DB 2基础:阐明表和表空间的状态),在对它执行SETintegrity语句之前,不能查询它。
Session locks can also be kept on the table that is being locked (or the root table of a set of tables).
会话锁还可保存在被锁定的表中(或表集合的根表中)。
Additionally, further constraints could also result in the table not being available right after the LOAD operation, requiring you to run the SET INTEGRITY SQL statement first.
此外,进一步的约束还可能导致在LOAD操作之后该表不可用,而要求您首先运行SETINTEGRITYsql语句。
Making changes to the SQL statement will affect the result data set being shown in the table or chart.
更改sql语句会影响在表或图中显示的结果数据集。
If the alter operation is an in-place alter, or if the participant mode is set to read-only for the replicated table being altered, the replay position is not moved.
如果alter操作是一个in - place alter,或者被修改复制表的参与者模式被设为只读,那么重放位置不会移动。
If there are additional filters that need to be applied to the data after the table access step, the rows will pass through that filter before being included in the final result set from that step.
如果有附加的过滤器需要在表访问步骤之后应用于数据,在被包括在,自那步起的最终结果集之前,行集将穿过过滤器。
The room was set up with a long head table and speaker's podium facing the 10 round tables where guests were being seated.
厅里摆放着一张贵宾桌和一个讲台,讲台对面是10张圆形客桌。
The room was set up with a long head table and speaker's podium facing the 10 round tables where guests were being seated.
厅里摆放着一张贵宾桌和一个讲台,讲台对面是10张圆形客桌。
应用推荐