O'Reilly logo

DB2® SQL PL: Essential Guide for DB2® UDB on Linux™, UNIX®, Windows®, i5/OS™, and z/OS®, Second Edition by Paul Yip, Fraser McArthur, Michael Gao, Raul Chong, Drew Bradstock, Clara Liu, Zamil Janmohamed

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required