Intelligent Enterprises of the 21st Century

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.

Tip

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