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

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