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的联邦过程。
Triggers Supports before row triggers, after row and statement triggers with trigger statements written in procedure language compound statements.
触发器支持行前触发器、行后触发器和语句触发器,触发器语句用过程语言复合语句编写。
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。
应用推荐