The SQL PL language is useful for writing stored procedures, user defined functions (UDFs) and triggers. The language is becoming more powerful with each release. This session will cover the basics of the language and give you some samples to take home and try!
Overview of SQL PL
Strengths and Limitations of SQL PL
Sample stored procedures for use anywhere!
Sample user defined functions for use anywhere!
SQL PL and Triggers
Access Path Stability on Db2 for z/OS - Best Practices
David Simpson, Themis
DB2 has provided some great features for stabilizing performance through changes in the environment, particularly through a DB2 version upgrade. In this session we will look at the evolution of access path stability over the last few releases and provide some thoughts on best practices for implementation.