DB2: "Trigger" a "Stored Procedure"?

greenspun.com : LUSENET : DBAzine : One Thread

We need a mechanism that will run a program when a row is inserted into a table in a DB2 database. Is it possible to code a Trigger that will invoke a COBOL Stored Procedure? It looks to me like Triggers are coded in SQL, and Stored Procedures are invoked via a Call statments from a client programs. I can't find where you can code a call statement in SQL, so maybe it's not possible. Any suggestions?

-- Jon Jones (aid952c@mail.idpa.state.il.us), October 02, 2002

Moderation questions? read the FAQ