CREATE TRIGGER subsystem.trigger-name AFTER UPDATE
REFERENCING OLD AS OLD
NEW AS NEW
FOR EACH ROW MODE DB2SQL
CALL subsystem.procedure-name (
you don't need the "current timestamp" but I just put it in there to show it can be done.
AFTER UPDATE can be changed to BEFORE UPDATE if you want
we've just successfuly done this.
using a DB2 trigger, call a DB2 Stored procedure written in COBOL.
what a pain in the @#$@#..
the only down side is I'm having problems "calling" other existing COBOL programs.. without this, I'm not sure what value these will add to our systems.