The original book was arguably the most popular IBM i publication with nearly 400,000 downloads over the past 9 years. And the notion of using SQL routines to manifest data-centric applications is a cornerstone of our solution development strategy. Not to mention that many new and significant DB2 enhancements have been delivered in the past decade.
The bottom line is this: it was time to rethink, revise and re-engineer the aging book: Stored Procedures, Triggers, and User-Defined Functions on DB2 Universal Database for iSeries.
One Becomes Two
The topic of DB2 SQL routines is now represented via two IBM Redbooks.
SQL Procedures, Triggers, and Functions on DB2 for i (SG24-8326-00) is the new book, focusing exclusively on SQL Routines and functionality in IBM i 7.1 and 7.2.
The original book has been edited to be: External Procedures, Triggers and Functions on DB2 for i (SG24-6503-03) and it is focused on external routines written in IBM i high level languages. Please keep in mind that while still relevant, the topic of external procedures, triggers and functions has not been updated or enhanced. The strategic language of relational database is Structured Query Language, and we encourage any new data-centric development to be done with SQL.
While the new book is undergoing a final polishing in the hands of the editor, you are encouraged to download the draft version here.
And of course, if you find yourself or your organization in need of assistance with getting the most out of DB2 for i, please do not hesitate to contact me - as the subject matters experts, the DB2 for i Center of Excellence can help.