Hi ,

I have a need to procees some task based on insertion/updation of a table.
For this I am planning to create a trigger which will tell me when there is any action(insert/update) on this table.

Now I need the way to call a cobol sub-routine from the trigger action part.
In COBOL sub-routine I need to validate the data in DB2, create XML and this XML I have to keep in the MQ.


Could any one please suggest me on this ?


Thanks in Advance,
Vijay.

You can write a UDF or stored procedure and call that from the trigger body.

Thanks Stolze. Could you please post a sample one for calling cobol sub-routine from a DB2 SP ??


Cheers
Vijay.

Sorry Stolze. Is COBOL SP or DB2 SP can be called from DB2 trigger ?

In DB2/LUW: Yes
In DB2/z: dunno