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 proceduresthat 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. These topics are covered in this chapter.


In DB2, you can also implement stored procedures in a host programming language such as C or Java.

    DB2 SQL PL. Deployment and Advanced Configuration Essential Guide for DB2 UDB on Linux., UNIX, Windows, i5. OS, z. OS
    Intelligent Enterprises of the 21st Century
    ISBN: N/A
    EAN: 2147483647
    Year: 2003
    Pages: 205 © 2008-2017.
    If you may any questions please contact us: