Stored procedures and triggers on db2 universal database for iseries
Hernando Bedoya, Daniel Lema, Cintia Marques, Vijay Marwaha · IBM Corp. eBooks · 2001
Develop robust UDB for iSeries applications Discover the details of SQL stored procedures Learn the secrets of SQL Triggers Stored procedures and triggers are the key database features for developing robust and distributed applications. In V5R1, SQL Triggers are supported on Universal Database for iSeries to give much more portability to the database. This IBM Redbook includes the latest announced features in V5R1 on stored procedures and triggers. Among the topics in this redbook, you will find suggestions, guidelines, and practical examples on how to effectively develop UDB for iSeries stored procedures and triggers. Some of the topics that are covered in this book include: - SQL stored procedures (SQL Persistent Stored Modules language) - External stored procedures and triggers - Java stored procedures (both JDBC and SQLJ) - SQL Triggers - External triggers This redbook also offers examples developed in several programming languages (RPG, COBOL, C, Java, and Visual Basic), using native and SQL data access interfaces. Some of the material in this redbook was originally published in the redbook DB2 UDB for AS/400 Database Functions, SG24-4249-02 . However, due to the importance of this information, we decided to move the topics of stored procedures and triggers into their own redbook. The remaining topics from the original book are covered in the updated redbook Advanced Functions and Administration on Universal Database for iSeries, SG24-4249-03 .