SQL procedures, triggers, and functions on IBM DB2 for i
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 versio...
| Autor Corporativo: | |
|---|---|
| Otros Autores: | , , , , , , , , |
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Poughkeepsie, NY :
IBM Corp. International Technical Support Organization
2016.
|
| Edición: | First edition |
| Colección: | IBM redbooks.
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009630223906719 |
| Sumario: | 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. |
|---|---|
| Notas: | "This edition applies to Version 7, Release 2, of IBM i (product number 5770-SS1)." "Power systems"--Cover. |
| Descripción Física: | 1 online resource (1 volume) : illustrations |
| Bibliografía: | Includes bibliographical references. |
| ISBN: | 9780738441641 |
