Can I use trigger in this manner?

[BMcFarland]

DB2 for OS/390 We have another system which is adding/updating data into several tables on our system via DB2CONNECT. When it is finished, it is updating a particular column to Y. Once that is done I was to kick off a COBOL program via the internal reader. Can I do that? My first thoughts are to set up an internal trigger on the column to be invoked when it is updated to Y. This trigger would in turn insert a set of data into a new table which would contain an external trigger on insert that would invoke a stored procedure passing it some key information. The stored procedure (a cobol program) would build the JCL and submit it thru the internal reader using the passed info as the parameter. Does this sound doable to anyone or do you have some better suggestions?

 

[MarcLodge]

Hi,
I've not done this, but can't see a problem with it. There's a very good article on triggers here:

http://www.dbazine.com/mullins_triggers.html

which you may find helpful
Marc