Issue Details (XML | Word | Printable)

Key: DERBY-115
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Minor Minor
Assignee: Unassigned
Reporter: Daniel John Debrunner
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Derby

BEFORE triggers missing from CREATE TRIGGER documentation

Created: 05/Jan/05 05:34 AM   Updated: 25/Jun/05 09:30 AM
Return to search
Component/s: Documentation
Affects Version/s: 10.0.2.1
Fix Version/s: 10.1.1.0

Time Tracking:
Not Specified

File Attachments:
  Size
Zip Archive Licensed for inclusion in ASF works derby115final2.zip 2005-06-25 09:02 AM Jeff Levitt 7 kB

Resolution Date: 25/Jun/05 09:30 AM


 Description  « Hide
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;


 All   Comments   Work Log   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Jeff Levitt made changes - 18/Jun/05 08:12 AM
Field Original Value New Value
Attachment derby115.zip [ 12310833 ]
Jeff Levitt made changes - 25/Jun/05 08:41 AM
Attachment derby115final.zip [ 12310950 ]
Jeff Levitt made changes - 25/Jun/05 09:02 AM
Attachment derby115final2.zip [ 12310951 ]
Jean T. Anderson made changes - 25/Jun/05 09:30 AM
Resolution Fixed [ 1 ]
Status Open [ 1 ] Closed [ 6 ]
Fix Version/s 10.1.1.0 [ 10993 ]