BurtNoir
0 pts. | May 18 2005 3:18PM GMT
I use the program data structure to get stuff while in a trigger program:
*
* Program status data structure to get the JOB & user id.
* ——————————————————-
D SDS
D JOB 244 253
D USER 254 263
byimw02
0 pts. | May 18 2005 3:33PM GMT
The method I have used to view who initiates a trigger program is to utilize the logging information in the table associated with the trigger. All our tables contain information noting who, how and when a record was inserted or changed. As noted in the other reply, journalling will collect detail information of all actions on a specific DB. You will have to construct a mechanism to retrieve the information in a readable format. The journal management reference manual should help if you choose this method. Good luck.






