How do you call a stored procedure using a trigger?
On insertion of a record into the table the trigger should call a stored procedure.How do we go about doing this..

Thanks,
Deepak B G

As far as I remember, as of now , you cannot call a SP from a trigger in DB2 LUW ... DB2 for z/os permits this ..

My apologies if I'm wrong

Sathyaram

IBM 390 MF using DB2 Vr 7.2.01

try this for the TRIGGER

CREATE TRIGGER subsystem.trigger-name AFTER UPDATE
ON subsystem.table-name
REFERENCING OLD AS OLD
NEW AS NEW
FOR EACH ROW MODE DB2SQL
BEGIN ATOMIC
CALL subsystem.procedure-name (
NEW.column_value1,
OLD.column_value1,
CURRENT TIMESTAMP,
);
END

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.