Skip to main content

SQL Procedures, Triggers, and Functions on IBM DB2 for i

An IBM Redbooks publication


Published on 25 April 2016

  1. .EPUB (3.3 MB)
  2. .PDF (4.5 MB)

Apple BooksGoogle Play Books

Share this page:   

ISBN-10: 0738441643
ISBN-13: 9780738441641
IBM Form #: SG24-8326-00

Authors: Hernando Bedoya, Jim Bainbridge, Rob Bestgen, Mike Cain, Dan Cruikshank, Jim Denton, Doug Mack, Tom Mckinley and Simona Pacchiarini

    menu icon


    Structured Query Language (SQL) procedures, triggers, and functions, which are also known as user-defined functions (UDFs), are the key database features for developing robust and distributed applications. IBM® DB2® for i supported these features for many years, and they are enhanced in IBM i versions 6.1, 7.1, and 7.2. DB2 for i refers to the IBM DB2 family member and relational database management system that is integrated within the IBM Power operating system that is known as IBM i.

    This IBM Redbooks® publication includes several of the announced features for SQL procedures, triggers, and functions in IBM i versions 6.1, 7.1, and 7.2. This book includes suggestions, guidelines, and practical examples to develop DB2 for i SQL procedures, triggers, and functions effectively.

    This book covers the following topics:

    • Introduction to the SQL/Persistent Stored Modules (PSM) language, which is used in SQL procedures, triggers, and functions
    • SQL procedures
    • SQL triggers
    • SQL functions

    This book is for IBM i database engineers and data-centric developers who strive to provide flexible, extensible, agile, and scalable database solutions that meet business requirements in a timely manner.

    Before you read this book, you need to know about relational database technology and the application development environment on the IBM Power Systems™ with the IBM i operating system.

    Table of Contents

    Chapter 1. Introduction to data-centric programming

    Chapter 2. Introduction to SQL Persistent Stored Module

    Chapter 3. SQL fundamentals

    Chapter 4. Procedures

    Chapter 5. Triggers

    Chapter 6. Functions

    Chapter 7. Development and deployment

    Chapter 8. Creating flexible and reusable procedures

    Chapter 9. IBM i and IBM DB2 for i services

    Appendix A. Allocating, describing, and manipulating descriptors

    Appendix B. Additional material


    Others who read this also read