DB2 SQL Procedural Language for Linux, Unix and Windows
by Yip, Paul; Bradstock, Drew; Curtis, Hana; Gao, Michael; Janmohamed, Zamil; Liu, Clara; McArthur, FraserEdition: CD
Format: Paperback w/CD
Pub. Date: 2003-01-01
Publisher(s): Prentice Hall PTR
Other versions by this Author
List Price: $59.99
Rent Textbook
Select for Price
New Textbook
We're Sorry
Sold Out
Used Textbook
We're Sorry
Sold Out
eTextbook
We're Sorry
Not Available
This item is being sold by an Individual Seller and will not ship from the Online Bookstore's warehouse. The Seller must confirm the order within two business days. If the Seller refuses to sell or fails to confirm within this time frame, then the order is cancelled.
Please be sure to read the Description offered by the Seller.
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. |
An electronic version of this book is available through VitalSource.
This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.
By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.
A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.
Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.
Please view the compatibility matrix prior to purchase.