Chapter 10. Leveraging DB2 Application Development Features
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, ...
Get DB2® SQL PL: Essential Guide for DB2® UDB on Linux™, UNIX®, Windows®, i5/OS™, and z/OS®, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
