Hi,

I need to write a trigger for delete operation. But it is not capturing the required details.

Whenever i perform delete operation on tableA, i need to capture col1 of tableA in AUDIT_table.

My trigger :
CREATE TRIGGER AUDIT_T1
AFTER DELETE ON tableA
REFERENCING OLD AS N_ROW
FOR EACH ROW MODE DB2SQL
BEGIN ATOMIC INSERT INTO AUDIT_table VALUES
((SELECT col1 FROM tableA WHERE N_ROW.col1 = tableA.col1)); END;

I appreciate your help on this. Thank you.

Regards
Prakash

See if this works

CREATE TRIGGER AUDIT_T1
AFTER DELETE ON tableA
REFERENCING OLD AS N_ROW
FOR EACH ROW MODE DB2SQL
INSERT INTO AUDIT_table(col1) VALUES(N_ROW.col1)

Cheers
Sathyaram

Thanks alot Sathyaram.

Regards
Prakash