SQL PL developers should use the corresponding function provided by the DB2 native compound SQL statements.
SQL PL开发人员应该使用DB 2原生复合sql语句提供的对应函数。
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。
应用推荐