- 论坛徽章:
- 0
|
关于触发器的初级问题,请用过的大虾指教
原帖由 "qm" 发表:
我想对一个物理文件加上一个更新触发器,触发执行一个没有关联意义的程序.
(没有用过触发器,想试试如何使用)
但是当调用一个对文件纪录进行更新的程序时,却出现CPF502B错误,然后我试着改了一些触发器添加时候..........
我做过的一点经验:
系统对BEFORE TRIGGER的一些限制:
· Statements not allowed in a trigger program are CONNECT, SET CONNECTION, RELEASE, DISCONNECT, and SET RESULT SETS.
· RUNSQLSTM is not allowed in a trigger program.
· COMMIT and ROLLBACK are not allowed in a trigger program if the trigger program is running in the same activation group as the triggering program. COMMIT and ROLLBACK are not allowed in an SQL trigger.
· ALTER TABLE is not allowed in a trigger program when commitment control is active.
· Statements not allowed in a stored procedure or user-defined function that is running on a remote application server are CONNECT, SET CONNECTION, RELEASE, DISCONNECT, COMMIT, ROLLBACK and SET TRANSACTION.
· Statements not allowed in an SQL BEFORE trigger are INSERT, UPDATE, DELETE, ALTER TABLE, COMMENT ON, CREATE, DROP, GRANT, LABEL ON, RENAME, and REVOKE.
· The RETURN statement is not allowed in an SQL trigger.
· Statements not allowed in a secondary thread are CREATE TRIGGER, CREATE FUNCTION (SQL), and CREATE PROCEDURE (SQL).
下面是ACTIVATION TIME为BEFORE时, |
-
1.JPG
(34.22 KB, 下载次数: 48)
|