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

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:

	File Name	Date Attached	Attached By	Size
	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:

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 ]