"External Trigger" in DB2 on zOS?

Anil Khanna · New User Joined: 06 Sep 2013 Posts: 15 Location: Cube

Hi,

Is there something called as "External Trigger" in DB2 on zOS as well? I've seen this for iSeries DB2 but not for DB2 on zOS?

Any pointers will be of great help.

GuyC · Posted: Tue Dec 03, 2013 1:13 pm

I believe a trigger can call an exterrnal stored procedure

dick scherrer · Posted: Tue Dec 03, 2013 7:57 pm

Hello and welcome to the forum,

If you explain what you want to happen (not how you intend to do it), we may be able to suggest ways to do it.

If there is a stored procedure that needs to be run occasionally*, you may be able to do what you using the system scheduling software.

* by time of day, or creation of some external dataset, completion of some job(s), etc.