Unanswered: insert stmt in BEFORE UPDATE trigger, supported? SQLSTATE: 42987
I'm trying to trace through a sequence of triggers to see what is happening and thought I would insert into a table when each trigger fired so I could capture the sequence of events. I am getting an error when I try to add an insert stmt to a particular trigger though. It works in an AFTER trigger, but not in a BEFORE trigger. I get a SQLSTATE: 42987 The trigger "<triggername>" is defined with an unsupported triggered SQL statement.
Can you not perform an insert into an unrelated table in a BEFORE UPDATE trigger, or is there maybe something else going on?
This is on Windows machine running DB2 PE 8.1 fp 9.