Hi Guys,

We have a requirement wherein when the value in the column of a particular DB2 table changes to a certain value, a job must be triggered which will execute a program and generate a report. This is in a Z/OS environment and we use DB2 for Z/OS version 8.

I had thought of the following solution for this –

Ø Create an ‘after update’ DB2 trigger which would call a DB2 stored procedure...