|
If you were logged in you would be able to see more operations.
|
|
|
| Resolution Date: |
25/Jun/05 09:30 AM
|
|
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;
|
|
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;
|
Show » |
|
Bug
Closed
Minor
BEFORE triggers missing from CREATE TRIGGER documentation
