SQLTrigger

000100 CREATE TRIGGER ROOMDELT
000200 AFTER DELETE ON HOG0009.ROOM
000210 REFERENCING OLD AS O
000300 FOR EACH ROW MODE DB2SQL
000400 BEGIN ATOMIC
000410 INSERT INTO HOG0009.LOGS(CHANGE_DESC) VALUES ('DELETE OF ' ||
000420 O.ROOM_DESCRIPTION);
000500 END @