DB2 for z/OS Stored Procedures - Trends and Technology

Stored procedures have been widely used for years in DB2 for Linux, UNIX, and Windows application environments. On the mainframe side, adoption of the technology was initially more limited. That situation is changing, thanks in part to the advent of native SQL procedures, delivered in DB2 for z/OS V9. This presentation will lay out a vision of a modern DB2 data-serving system in which stored procedures play a very important role. It will also provide a review of DB2 for z/OS stored procedure enhancements through DB2 10, with a particular emphasis on the advantages of native SQL procedures. The presentation will conclude with some hints, tips, and go-forward recommendations.