SQL procedures, triggers, and functions on IBM DB2 for i / Jim Bainbridge, Hernando Bedoya, Rob Bestgen, Mike Cain, Dan Cruikshank; Jim Denton; Doug Mack; Tom Mckinley; Simona Pacchiarini.

Format:

Book

Author/Creator:

Bainbridge, Jim, author.

Pacchiarini, Simona, author.

Bedoya, Hernando, author.

Bestgen, Rob, author.

Cain, Mike, author.

Cruikshank, Dan, author.

Denton, Jim, author.

Mack, Doug, author.

Mckinley, Tom, author.

Contributor:

International Business Machines Corporation. International Technical Support Center.

Series:

IBM redbooks.

IBM redbooks

Language:

English

Subjects (All):

IBM Database 2.

SQL (Computer program language).

Physical Description:

1 online resource (1 volume) : illustrations.

Edition:

First edition.

Place of Publication:

Poughkeepsie, NY : IBM Corp. International Technical Support Organization, 2016.

System Details:

text file

Summary:

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.

Notes:

"This edition applies to Version 7, Release 2, of IBM i (product number 5770-SS1)."

"Power systems"--Cover.

Description based on online resource; title from title page (viewed June 6, 2016).

Includes bibliographical references.

ISBN:

9780738441641

0738441643

OCLC:

951425088