[ http://issues.apache.org/jira/browse/DERBY-115?page=comments#action_12314447 ]
Daniel John Debrunner commented on DERBY-115: --------------------------------------------- In the Triggered-SQL-statement section, an additiona limitation is that before triggers can not have INSERT, UPDATE or DELETE statements as their action. > BEFORE triggers missing from CREATE TRIGGER documentation > --------------------------------------------------------- > > Key: DERBY-115 > URL: http://issues.apache.org/jira/browse/DERBY-115 > Project: Derby > Type: Bug > Components: Documentation > Versions: 10.0.2.1 > Reporter: Daniel John Debrunner > Priority: Minor > Attachments: derby115final.zip > > Derby does support before triggers, syntax is the same as after triggers, > but replace AFTER with NO CASCADE BEFORE. Eg. > create trigger t1 > NO CASCADE BEFORE insert on x > referencing new_table as newrowtab > for each statement mode db2sql > insert into y select x from newrowtab; -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira
