Re: Retrieve Program name that caused Trigger

[John Hall <jhall@xxxxxxxxxxx>]

I believe journaling will do all of that for you.  I am not sure of the
sequence of a journal entry vs a trigger but we use the journals to tell
us exactly which program changed the data.  Also journals are
asynchronous to the database so if you update 10,000 records you don't
have 10,000 API calls in the trigger to slow down your processing.  

Journals are a GREAT debugging tool.  The more complex the application
the more useful the journals become.

John Hall
Home Sales Co.

"Kellems, Cary" wrote:
> 
> I have created a trigger program that creates an audit file which includes
> the job information of the job initiating the trigger program(via QUSRJOBI).
> I would like to also include the particular program name responsible for the
> trigger action.  Is this possible?
> 
> Regards,
> Cary Kellems
> Thanks
+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---