Therefore during merge-insert operation, only for-each-row insert triggers on the target table are activated.
因此,在merge -insert操作过程中,仅激活目标表上的for - each -row insert触发器。
In fact, when this feature is enabled, and the INSERT operation requires a new or reused block, DB2 will take an exclusive (x) lock on the block in order to add it to the target cell.
实际上,当该特性被启用,并且INSERT操作要求一个新的或重用的块时,DB 2将在块上采用一个独占的(X)锁,以便将它添加到目标单元。
Having mentioned possible collisions between the outer and the inner legs of a join, it should also be mentioned that a similar problem could occur between the function and the INSERT operation.
提到连接的内表和外表之间各种可能的冲突之后,还应该提到的是,在这个函数与INSERT操作之间也可能发生类似的问题。
Having mentioned possible collisions between the outer and the inner legs of a join, it should also be mentioned that a similar problem could occur between the function and the INSERT operation.
提到连接的内表和外表之间各种可能的冲突之后,还应该提到的是,在这个函数与INSERT操作之间也可能发生类似的问题。
应用推荐