Stored Procedures, Triggers, and User-Defined Functions on DB2 Universal Database for iSeries

An IBM Redbooks publication


Stored procedures, triggers, and user-defined functions (UDFs) are the key database features for developing robust and distributed applications. DB2 Universal Database for iSeries has supported these features for many years, and they have been enhanced in V5R1, V5R2, and V5R3 of IBM OS/400 and V5R4 of IBM i5/OS.

This IBM Redbooks publication includes some of the announced features for stored procedures, triggers, and UDFs in V5R1, V5R2, V5R3, and V5R4. Among the topics in this book, you will find suggestions, guidelines, and practical examples on how to effectively develop DB2 Universal Database for iSeries stored procedures, triggers, and UDFs. Some of the topics that are covered in this book include:

  • Introduction to the SQL Persistent Stored Module Language
  • SQL stored procedures
  • External stored procedures and triggers
  • Java stored procedures
  • SQL triggers
  • External triggers
  • SQL UDFs
  • External UDFs

This book also offers examples that were developed in several programming languages, including RPG, COBOL, C, Java, and Visual Basic, using native and SQL data access interfaces.

Table of contents

Part 1. Background
Chapter 1. Introducing DB2 Universal Database for iSeries
Chapter 2. Stored procedures, triggers and user-defined functions: Order entry application
Chapter 3. Introduction to the SQL Persistent Stored Module in DB2 Universal Database for iSeries
Part 2. Stored procedures
Chapter 4. Stored procedures
Chapter 5. SQL stored procedures
Chapter 6. External stored procedures
Chapter 7. Java stored procedures
Chapter 8. Stored procedure error handling
Part 3. Triggers
Chapter 9. Database triggers
Chapter 10. SQL triggers
Chapter 11. External triggers
Chapter 12. Triggers, referential integrity, and constraints
Part 4. User-defined functions
Chapter 13. User-defined functions
Chapter 14. SQL user-defined functions
Chapter 15. External user-defined functions
Appendix A. Sample ILE C program using the QDBRTVFD API
Appendix B. Order Entry application: Detailed flow
Appendix C. Stored procedures and trigger porting considerations
Appendix D. Additional material


Publish Date
24 October 2006

(based on 8 reviews)




IBM Form Number

Number of pages