Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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 @
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
