AW: How to detect what program triggered the trigger?

Hi,

just an additional comment:

When a trigger is fired the database manager invokes a program in the call
stack that calls the trigger program.
For an insert trigger QDBPUT is invoked and for all other triggers QDBUDR is
invoked.
To get the program that fired the trigger, you only have to use the small
CL-Program from the FAQ with either QDBPUT or QDBUDR as called program.

Birgitta

-----Ursprungliche Nachricht-----
Von: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]Im Auftrag von
GKern@xxxxxxxxxxxxxxxx
Gesendet: Freitag, 11. Februar 2005 19:04
An: rpg400-l@xxxxxxxxxxxx
Betreff: Re: How to detect what program triggered the trigger?


Thanks Mark & Raul. I found Scott Klement's article on the iSeries Network
website. That allows me to do what you are both suggesting. It looks like
it is exactly what I need to do.

Happy Friday !

Regards, Jerry

Gerald Kern
IBM Certified AS/400 RPG IV Developer & RPG IV Programmer
MIS Project Leader, Lotus Notes/Domino Administrator
The Toledo Clinic, Inc.
4235 Secor Road
Toledo, OH 43623-4299
Phone 419-479-5535
gkern@xxxxxxxxxxxxxxxx

*****
This email message, including any attachments, is for the sole use of the
intended recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or distribution is
prohibited. If you are not the intended recipient, please contact the sender
by reply email and destroy all copies of the original message.