Re: Triggers not always executing.

May be this option

Trigger update condition . . . .   *ALWAYS       *ALWAYS, *CHANGE(second page)




                                                                                
                                                        
                      GKern@toledoclinic                                        
                                                        
                      .com                      To:       rpg400-l@xxxxxxxxxxxx 
                                                        
                      Sent by:                  cc:                             
                                                        
                      rpg400-l-bounces@m        Subject:  Triggers not always 
executing.                                                
                      idrange.com                                               
                                                        
                                                                                
                                                        
                                                                                
                                                        
                      04/26/04 11:37 AM                                         
                                                        
                      Please respond to                                         
                                                        
                      RPG programming on                                        
                                                        
                      the AS400 /                                               
                                                        
                      iSeries                                                   
                                                        
                                                                                
                                                        
                                                                                
                                                        




Does anyone know of any type of DB commands/utilities that could be used
to diagnose trigger processing?

I have a situation where record updates should trigger a program to
execute but for some reason the trigger doesn't always execute. Almost all
of the time (99.9%) of the time the trigger appears to work.

I wrote the trigger program, and included code in it to log triggered
update requests to a logfile. Other than logging the trigger requests, is
there anything else I can do to monitor the triggers?

Regards,

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 is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.