Re: Information available when a db2 trigger fires off/calls an rpg program.

Hi John,

Years ago there was a programming tip called rtvtrgpgm, I think it was
published by Centerfield Technology but I can't find it on Google anymore.
The utility uses the QWVRCSTK API. I have used the code in the tip to
retrieve the calling program from the stack.

I have posted the code here: https://code.midrange.com/a42d7df95f.html

Hope that helps!

Best regards,
-Arco

2018-01-31 20:49 GMT+01:00 <JRusling@xxxxxxxxxxx>:

When a process/program updates a file and causes the trigger to fire which
then calls an rpg program --

1. Is the process/program that updated the file available to the rpg
program? (ie DBU, STRSQL, RUNSQLSTM or another program)

2. Is the user id which the process/program is running under available to
the rpg program?
(I am assuming yes via the pgm status data structure)

Thanks for any help, tips or direction.

John
<br />
The information in this email is confidential and may be legally
privileged.
It is intended solely for the addressee. Access to this email by anyone
else is
unauthorized. If you are not the intended recipient, any disclosure,
copying,
distribution or any action taken or omitted to be taken in reliance on it,
is
prohibited and may be unlawful.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD