Time to get trigger-happy (not in the western-movie way) as I’ll introduce you to your new best friend: the SQL trigger. Keep reading to find out what I’m talking about!
By Rafael Victória-Pereira
If you’re not familiar with the trigger concept in IBM i’s context, it is a Big Brother–like “thing” that keeps an eye on a table and, when a certain operation occurs, performs a predefined action. In a silly analogy, if a table was one of Pavlov’s dogs, and the INSERT/UPDATE/DELETE operation was the light the scientist controlled, then the trigger would be the reflex action causing the dog to come running and start drooling.