var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: db2 delete trigger
Can anyone tell me how can I define a trigger in db2 that copies some rows from a table to another one, when those rows are deleted from the first one?
I haven't studdied much this problem, but I tried in different ways and then I read that a before trigger can't perform an insert operation.
Re: db2 delete trigger
I have two tables tdeltrig and tdeltrig1 with columns i and j (both integers)
CREATE TRIGGER ADELTRIG
AFTER DELETE ON TDELTRIG
REFERENCING OLD AS O
FOR EACH ROW MODE DB2SQL
INSERT INTO TDELTRIG_1(I,J) VALUES(O.I,O.J)
See if this works
Visit the new-look IDUG Website
, register to gain access to the excellent content.