How can I identify the 'calling event' (program, SQL, ODBC, etc.) that launches a trigger program?

DB2 UDB does not provide any components in it's trigger to determine this. Some iSeries programmers have used the Send & Receive Message APIs (QMHSNDPM & QMHRCVPM) where the program uses API QMHSNDPM to send a message to the message queue of the changing program's call-stack entry. API QMHRCVPM then retrieves the message from the message queue, obtaining the name of the program associated with that entry in the process.

==================================
MORE INFORMATION ON THIS TOPIC
==================================

Search400.com's targeted search engine: Get relevant information on DB2/400.

The Best Web Links: tips, tutorials and more.

Check out this online event, Getting the Most out of SQL & DB2 UDB for the iSeries.


This was first published in June 2003