Re: Trigger program

["Peter Dow" <pcdow@xxxxxxxxx>]

Hi Bill,

Journalling does indeed tell not only when and what program, but also which
user and what job. The only situation I can think of where this might not
provide *useful* information is with ODBC drivers or a DDM file. However, a
trigger program will show no more than journalling would.

For more information on trigger programs, see Chapter 17. Triggers in the
OS/400 DB2 for AS/400 Database Programming manual.

Regards,
Peter Dow
Dow Software Services, Inc.
909 425-0194 voice
909 425-0196 fax



----- Original Message -----
From: Bill Graziano <Bill.Graziano@besi.com>
To: <RPG400-L@midrange.com>
Sent: Friday, October 22, 1999 4:21 AM
Subject: Trigger program


> I have a file that is being written to an excessive number of times. For
> example, one record should be written for each of 40 business locations.
> Instead of one record, as many as 400 records are being written for some
> business locations. I am trying to pin down when and by which program are
> the records being written. According to my system administrator,
journaling
> did not help determine this. I believe that I need to add a physical file
> trigger and write a trigger program.
>
> I have not written any trigger programs and need some suggestions. I have
> identified the file update program. What I need to know is when is this
> update program being executed and, if possible, what program is calling
the
> file update program. Any suggestions or ideas will be greatly appreciated.
>
> Thanks,
> Bill Graziano
>
> +---
> | 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
> +---


__________________________________________________
Do You Yahoo!?
Bid and sell for free at http://auctions.yahoo.com

+---
| 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
+---