To avoid too much complexity, DB2 imposes a simple rule: an UPDATE, DELETE or INSERT (data-change-operation) shall never happen in a join unless embedded in a correlated function.
为了避免太多的复杂性,DB 2强加了一条简单的规则:除非嵌入在相关的函数里面,否则UPDATE、DELETE或INSERT(数据更改操作)不应该出现在连接中。
Finally, there is one more novel feature related to data-change-operations exposed in this transaction: the INCLUDE-clause which INSERT, like any other data-change-operation, can use.
最后,在这个事务中还暴露了有关数据更改操作的另一个更新颖的特性:那就是INCLUDE -子句,像任何其他数据更改语句一样,INSERT可以使用这个子句。
MODIFIES SQL DATA in SQL table functions allows you to push even INSERT, UPDATE, DELETE and MERGE (data-change-operations) into the inner leg of correlated joins.
SQL 表函数中的 MODIFIES SQL DATA 使您甚至可以将 INSERT、UPDATE、DELETE 和 MERGE ( 数据更改操作)放入到关联连接的内表中。
应用推荐