RE: Trigger pgm: user & pgm id

["Kempter, Eric" <EKempter@xxxxxxxxxx> (by way of David Gibbs <david@xxxxxxxxxxxx>)]

The trigger process is discussed in depth in the OS/400 DB2 for OS/400   
Database Programming V3R2 manual at:
http://as400bks.rochester.ibm.com/cgi-bin/bookmgr/bookmgr.cmd/BOOKS/QBKAUC  
01/3.8

I hope that this helps!


 -----Original Message-----
From: midrange-l-owner [SMTP:midrange.com!midrange-l-owner@mcs.com]
Sent: Wednesday, November 05, 1997 9:33 AM
To: MIDRANGE-L
Subject: Trigger pgm: user & pgm id

I would like to identify the program and user that tripped the *UPDATE
trigger when
they were updating a database file.  We are using V3R1, not under   
journaling,
commitment control, or ILE.  Just OPM Cobol at the moment.  What (CL)   
command
can
I use in my (Cobol) trigger program to identify this?  (We want to place   
the
before and
after images of the database change in a history file, with time, user   
and
program that
made the change.)

TIA.
Karen Bellecci
kbellecci@osfa.state.la.us
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to "MIDRANGE-L@midrange.com".
| To unsubscribe from this list send email to MAJORDOMO@midrange.com
|    and specify 'unsubscribe MIDRANGE-L' in the body of your message.
| Questions should be directed to the list owner/operator:   
david@midrange.com
+---
uucp


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to "MIDRANGE-L@midrange.com".
| To unsubscribe from this list send email to MAJORDOMO@midrange.com
|    and specify 'unsubscribe MIDRANGE-L' in the body of your message.
| Questions should be directed to the list owner/operator: david@midrange.com
+---