zOs/SQL/CRETRI

SET CURRENT SQLID = 'S100447';
CREATE TRIGGER DGDB9998.WK003TRIG
  AFTER DELETE ON GDB9998.TWK003A
    REFERENCING OLD AS OLD
    FOR EACH ROW       MODE DB2SQL
    INSERT INTO GDB9998.TWK003A
      (WK003ID,
       WK003TXT,
       WK003FOR)
    VALUES (  OLD.WK003ID,
              'DELETETRIGGER',
              OLD.WK003FOR
           )
;
COMMIT;