In this chapter, you will learn
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.