Re: Use of Triggers in RPG

Instead of using triggers, which may cause extra overhead when writing to
the transaction files, you could journal the files and set up a batch job
to receive the journal entries and then write the journal information to a
log file.

just a thought...
Todd



                                                                           
             "PAPWORTH  Paul"                                              
             <Paul.Papworth@sl                                             
             ib.fr>                                                     To 
             Sent by:                  <rpg400-l@xxxxxxxxxxxx>             
             rpg400-l-bounces@                                          cc 
             midrange.com                                                  
                                                                   Subject 
                                       Use of Triggers in RPG              
             07/26/2005 11:55                                              
             AM                                                            
                                                                           
                                                                           
             Please respond to                                             
              RPG programming                                              
              on the AS400 /                                               
                  iSeries                                                  
             <rpg400-l@midrang                                             
                  e.com>                                                   
                                                                           
                                                                           




I would be pleased to know if any one has any examples and/or advice on
how the use Triggers to log updates to a a stats file each time there is
a record written to a number of transaction files. Is this even a viable
approach ? What are the pitfalls ?



Many thanks in advance



Paul Papworth

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