Are you aware of everything you can do with triggers in i5/OS or OS/400?
One of IBM's better-kept secrets in V5R1 is the significant new trigger function provided in the OS/400 release. This ranges from SQL triggers, which provide a high degree of flexibility not found with external triggers, to read triggers, which can have a serious detrimental effect on system performance and throughput. These are the enhancements:
Read triggers (approach with extreme caution!)
Multiple triggers per database or trigger event
Named triggers
Change Physical File Trigger (CHGPFTRG) command
System Catalog trigger enhancements
SQL triggers
Let's review each one of these in detail, starting with the read trigger.
