DATE: 2010-11-10 (17:00 - 18:00)SPEAKERS: Robert Catterall (Catterall Consulting)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 has been somewhat more limited. That situation is likely to change with 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, with a particular emphasis on the advantages of DB2 V9 native SQL procedures. The presentation will conclude with some hints, tips, and go-forward recommendations.EXP. LEVEL: Beginner,Intermediate,AdvancedOBJECTIVES:A vision of a modern DB2 for z/OS data-serving system, with stored procedures as a foundational element.Advances in DB2 for z/OS stored procedure functionality since DB2 V4.DB2 9 for z/OS native SQL procedures - whatGo-forward recommendations regarding the implementation of DB2 9 for z/OS native SQL procedures.Some DB2 for z/OS stored procedure hints and tips.