Whipping Up an RPGLE
After Image Trigger Program

This technical article features a video showing how to create a trigger program that captures the after images of records in a Db2 for i database file, at the moment the DB change occurs.  The trigger program captures changes made via any program, raw data file editor utility (such as DFU), or SQL process happening on the local IBM i or any remote machine.   

This video and presentation and code download is available for free for a limited time, once you have a verified non-consumer level Web User ID.

• To tune in to the soft-coded trigger program concept using RPG ILE Free as the high-level language on IBM i
  
  
• We want to learn this method for quickly enabling and implementing a master file auditing log software function, and do it without affecting the current programs and processes that manipulate the master file
  
  
• We were unable to catch this presentation at COMMON's Navigate 2021 technical conference
  
  
• We need to be able to look back many months to see the User ID and/or User Profile who last changed a column value in a master file record, and to do it without loading and/or searching through a hundred journal log files
  
  

Here are the prerequisites:

• a Db2 for i database file
  
• an RPGLE compiler and a CLP compiler on IBM i 6.1 OS or greater

1. Check in with your name and company and email address (we guarantee we won't email or contact you based on this registration (from us or a 3rd party), other than we might send you, at most, two survey emails (directly from us))  
   1. We'll email you with a link and temp password that enables you to set your permanent password (and simultaneously for us to indicate your email address is verified)
      
      
2. Then Click on above Picture (showing slide 11 in video presentation)
   1. We'll immediately send you to a temporary .html address on tegratecs.com linking you directly to the 16 1/2 minute streaming video content, Whipping Up an RPGLE After Image Trigger Program right on this site, a $30 value, which you can watch up to 3 times per day
      
      
3. Hurry, this presentation and template code download will be available without charge only for a very limited time.