In this chapter, you will learn how to
Take advantage of enhanced SQL features for better performance
Use declared global temporary tables
Share temporary table data across multiple procedure calls
Use save points for finer transaction control
Wrap sequence objects in stored procedures to improve application portability
At this point, you should know almost everything about writing DB2 SQL procedures. You have learned about SQL PL structure, flow control, cursor usage, condition handling, dynamic SQL, and using nested procedure calls. The focus of this chapter is on DB2 application development features that are not part of SQL PL per se but are commonly employed in SQL procedures, functions, ...