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 Redbook includes some of the announced features for stored procedures, triggers, and UDFs in V5R1, V5R2, V5R3, and V5R4. Among the topics in this IBM Redbook, 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 IBM Redbook 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. |
