DB2 SQL Procedural Language for Linux, Unix and Windows

by Yip, Paul; Bradstock, Drew; Curtis, Hana; Gao, Michael; Janmohamed, Zamil; Liu, Clara; McArthur, Fraser

• ISBN13: 9780131007727
• ISBN10: 0131007726
• Edition: CD
• Format: Paperback w/CD
• Copyright: 2003-01-01
• Publisher: Prentice Hall PTR

Summary

SQL Procedure Language (SQL PL) is used in DB2 to write database-stored procedures. Stored procedures are used to encapsulate business logic on the database and yield the following benefits: significantly improved application performance, increased application scalability, simplified application development, and reduced network traffic. This book will teach the reader how to set up the development environment and use all language elements of SQL PL through concrete examples and thorough discussions. Also included are expert tips and best practices for achieving optimal performance and code manageability. This book will be a valuable reference for SQL PL code syntax and troubleshooting. There are currently no books on the market that cover the DB2 SQL Procedure Language, although it is extensively used by IBM business partners and other software vendors.

Table of Contents

About the Authors
Acknowledgments
Introduction	p. 1
Basic SQL Procedure Structure	p. 11
Using Flow of Control Statements	p. 31
Understanding and Using Cursors and Result Sets	p. 57
Condition Handling	p. 75
Working with Dynamic SQL	p. 103
Working with Nested SQL Procedures	p. 119
Leveraging DB2 Advanced Features	p. 135
Deploying SQL Procedures	p. 171
Working with Triggers and User-Defined Functions	p. 185
Getting Started with DB2	p. 205
Setting up the Build Environment	p. 223
Using the DB2 Development Center	p. 231
Security Considerations in SQL Procedures	p. 251
Built-in Function Reference	p. 257
DDL	p. 271
Additional Resources	p. 277
Sample Application Code for Receiving Cursor Result Sets	p. 285
SQL PL Cross-Platform Compatibility	p. 299
Index	p. 309
Table of Contents provided by Blackwell. All Rights Reserved.