db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Stephen Ince" <si...@opendemand.com>
Subject before update trigger
Date Wed, 04 Jul 2007 16:06:54 GMT
Hi,
   I am currently trying to port over a schema from postgres and I am little 
stuck.

1) Does derby support before update triggers. If not is there a plan to 
support this feature?
e.g.
CREATE TRIGGER setIfServiceKeysOnUpdate2Trigger
BEFORE UPDATE ON outages

2) Does derby support calling a procedure from a trigger? I can't seem to 
get this to work.
CREATE TRIGGER setIfServiceKeysOnUpdate2Trigger
BEFORE UPDATE ON outages
FOR EACH ROW MODE DB2SQL
CALL myprocy();

3) I noticed that db2 supports the "when" clause, but derby doesn't. Are 
there any plans to support some type "if" statement for a trigger.

Steve 


Mime
View raw message