SQL Procedures, Triggers, and Functions on IBM DB2 for i
Hernando Bedoya · Jim Bainbridge · Rob Bestgen · Mike Cain · Dan Cruikshank · Jim Denton · Doug Mack · Tom Mckinley · Simona Pacchiarini · IBM Redbooks
Apr 2016 · IBM Redbooks
4.6star
20 reviewsreport
Ebook
338
Pages
family_home
Eligible
info
reportRatings and reviews aren’t verified Learn More
About this ebook
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 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.
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 SystemsTM with the IBM i operating system.
Ratings and reviews
4.6
20 reviews
Tulasi Ho
- Flag inappropriate
- Show review history
October 22, 2023
AÀA BOSS NETWORK
Anil Das
- Flag inappropriate
October 27, 2021
AÀA BOSS NETWORK
Anil Das
- Flag inappropriate
July 16, 2021
AÀA BOSS NETWORK
1 person found this review helpful
Rate this ebook
Tell us what you think.
Reading information
Smartphones and tablets
Install the Google Play Books app for Android and iPad/iPhone. It syncs automatically with your account and allows you to read online or offline wherever you are.
Laptops and computers
You can listen to audiobooks purchased on Google Play using your computer's web browser.
eReaders and other devices
To read on e-ink devices like Kobo eReaders, you'll need to download a file and transfer it to your device. Follow the detailed Help Center instructions to transfer the files to supported eReaders.
