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 can be used to encapsulate business logic at the database server. We will discuss stored procedures and user-defined functions that can be used for better application management and for secure and robust application design. We will also discuss how...