Chapter 8. Nested SQL Procedures
In this chapter, you will learn
What nested SQL procedures are
How to pass parameters between nested SQL procedures
How to return values from nested SQL procedures
How to return and receive result sets from within nested SQL procedures
How to write recursive SQL procedures
Various security techniques you should employ in nested SQL procedures
DB2 supports nesting of SQL procedures—that is, invoking an SQL procedure from another SQL procedure.
While all the information described in this book so far is applicable to nested SQL procedures, you need a little more information on how to pass data between SQL procedures so that they work together effectively. For example, some SQL statements are unique to nested SQL procedures. ...
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.
