The usage of a temporary table limits tracing to procedures of the class MODIFIES SQL DATA.
临时表的使用限制了对属于MODIFIES SQL data类别的过程的跟踪。
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 （ 数据更改操作）放入到关联连接的内表中。
Federated procedures with access level MODIFIES SQL DATA cannot be invoked inside triggers, dynamic compound statements, scalar, table, row functions, and methods.
在触发器、动态合成语句、标量、表、行函数和方法中不能调用具有访问级别MODIFIES SQL DATA的联邦过程。
IF it has MODIFIES SQL DATA, it is blocked in triggers, dynamic compound statements, SQL-bodied functions, or when a save point has been created, and error SQL30090 with reason code 22 is returned.
如果访问级别是MODIFIES SQL DATA，那么它在触发器、动态合成语句、sql体函数中或在创建保存点时会阻塞，并返回原因码为22的错误SQL 30090。
IF it has MODIFIES SQL DATA, it is blocked in triggers, dynamic compound statements, SQL-bodied functions, or when a save point has been created, and error SQL30090 with reason code 22 is returned.
如果访问级别是MODIFIES SQL DATA，那么它在触发器、动态合成语句、sql体函数中或在创建保存点时会阻塞，并返回原因码为22的错误SQL 30090。
应用推荐