Re: After Read trigger fires multiple times

[rob@xxxxxxxxx]

Depending on what version of OS/400 you are running, you can have a large 
number of triggers associated with a file.  Any chance you did the 
ADDPFTRG multiple times?
DSPFD and search for "Number of triggers".

Failing that, you don't try to change the record by reading it from the 
file, do you?  If so, I recommend you use the trigger buffer.  Wait - 
that's on a write or update.
Are you modifying the record to store a "last read timestamp"?  Because if 
you are, and the trigger reads the record to update it, that could be some 
interesting loop.

Rob Berendt
-- 
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





GKern@xxxxxxxxxxxxxxxx 
Sent by: midrange-l-bounces@xxxxxxxxxxxx
02/24/2005 10:56 AM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
midrange-l@xxxxxxxxxxxx
cc

Subject
After Read trigger fires multiple times






I have a trigger on a file, set to execute on an after read operation.

For some reason, the trigger fires three times for a read operation. 

In my debugging (using DBU to view a record), the trigger program is being 

called three times. I've queried the file and it shows that the record 
exists only once in the file.

Anyone with any input as to cause or why this is happening? 

Regards, Jerry

Gerald Kern
IBM Certified AS/400 RPG IV Developer & RPG IV Programmer
MIS Project Leader, Lotus Notes/Domino Administrator
The Toledo Clinic, Inc.
4235 Secor Road
Toledo, OH 43623-4299
Phone 419-479-5535
gkern@xxxxxxxxxxxxxxxx

*****
This email message, including any attachments, is for the sole use of the 
intended recipient(s) and may contain confidential and privileged 
information. Any unauthorized review, use, disclosure or distribution is 
prohibited. If you are not the intended recipient, please contact the 
sender by reply email and destroy all copies of the original message.-- 
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: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.