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
