Chapter 4. Procedures, Functions, Triggers, and Modules
In this chapter, we will focus on the following recipes related to DB2 routines, triggers, and modules:
- Creating a simple stored procedure
- Using dynamic SQL in stored procedures
- Working with result sets in stored procedures
- Using ARRAY objects in stored procedures
- Handling errors in stored procedures
- Designing external stored procedures
- Using PL/SQL exception handling in a procedure
- Working with the message buffer in stored procedures
- Planning and designing triggers
- Using scalar user-defined functions
- Writing external user-defined functions
- Designing external table functions
- Working with modules in DB2
Introduction
In this chapter, we will look at the different types of functional database objects that ...
Get IBM DB2 9.7 Advanced Application Developer Cookbook 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.
