DB2 SQL PL : essential guide for DB2 UDB on Linux, UNIX, Windows, i5/OS, z/OS
| Main Author: | |
|---|---|
| Format: | Book |
| Language: | English |
| Published: |
Upper Saddle River, New Jersey :
Pearson ,
c2005
|
| Edition: | 2nd ed |
| Subjects: |
Table of Contents:
- 1. Introduction
- 2. Basic SQL procedure structure
- 3. Overview of SQL PL language elements
- 4. Using flow of control statements
- 5. Understanding and using cursors and result sets
- 6. Condition handling
- 7. Working with dynamic SQL
- 8. Nested SQL procedures
- 9. User-defined functions and triggers
- 10. Leveraging DB2 application development features
- 11. Deploying SQL procedures, functions, and triggers
- 12. Performance tuning
- 13. Best practices