SQL Procedures, Triggers, and Functions on IBM DB2 for i
Hernando Bedoya and Others
This book can be downloaded and read in iBooks on your Mac or iOS device.
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
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.
Customers Also Bought
- Modernizing IBM i Applications from the Database up to the User Interface and Everything in Between
- Nadir K. Amra, Hernando Bedoya, Tony Cairns, Dan Cruikshank, Rich Diedrich, John Eberhard, Mark Evans, Antonio Florez, Susan Gantner, Jesse Gorzinski, Isaac Ramírez Herrera, Brian May, Michel Mouchon, Jon Paris, Mike Pavlak, Trevor Perry, Pascal Polverini, Jim Ritchhart, Tim Rowe, Jon Rush, Paul Tuohy, Jeroen Van Lommel & Carol Woodbury
- Category: Computers
- Published: Apr 25, 2016
- Publisher: IBM Redbooks
- Seller: International Business Machines Corp
- Print Length: 338 Pages
- Language: English