[DERBY-115] BEFORE triggers missing from CREATE TRIGGER documentation

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 10.0.2.1
• Fix Version/s: 10.1.1.0
• Component/s: Documentation
• Assignee: Unassigned
• Reporter: Daniel John Debrunner
• Created: 05/Jan/05 05:34
• Updated: 25/Jun/05 09:30
• Resolved: 25/Jun/05 09:30

Description

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;