SQL Triggers and Other New Trigger Functions in V5R1
Skip Marchesani
SQL Triggers and Other New Trigger Functions in V5R1
IBM has announced significant new enhancements for triggers in V5R1, which will be reviewed in detail in this session. Did you know that the dreaded Read Trigger can slow your system to a crawl, you can now have multiple triggers per database event, and your triggers must now be given names? Are you aware that you can disable or enable a trigger with the new CHGPFTRG command, trigger information is logged in the system catalog, and there is a powerful new SQL trigger function. If the answer to some or all of these questions is No, you need to hear what IBM has done with triggers in V5R1. A basic understanding of trigger concepts is required.
Skip Marchesani retired from IBM after 25 years and is now a consultant with Custom Systems Corp, an IBM Business partner. Recognized as an industry expert on DB2/400 and author of the book 'DB2/400': The New AS/400 Database', he specializes in providing customized education for any area of the AS/400, does database design and design reviews, and general AS/400 consulting for interested clients. He has been a speaker for user groups, technical conferences, and AS/400 audiences around the world. Skip is an award winning COMMON speaker and has received their Distinguished Service Award.