DB2 SQL Procedural Language for Linux, UNIX, and Windows

Front Cover
Prentice Hall Professional, 2003 - Computers - 315 pages
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.
 

What people are saying - Write a review

We haven't found any reviews in the usual places.

Contents

Introduction 1
xix
Basic SQL Procedure Structure
11
Using Flow of Control Statements
31
Understanding and Using Cursors and Result Sets
57
Condition Handling
75
Working with Dynamic SQL
103
Working with Nested SQL Procedures
119
Leveraging DB2 Advanced Features
135
Chapter 1O Working with Triggers and UserDefined
185
Appendix A Getting Started with DB2
205
Appendix B Setting up the Build Environment
223
Security Considerations in SQL Procedures
251
Appendix F DDL
271
Appendix H Sample Application Code for Receiving Cursor
285
SQL PL CrossPlatform Compatibility
299
Copyright

Deploying SQL Procedures
171

Common terms and phrases

About the author (2003)

Paul Yip is a member of the core DB2 development team at the IBM Toronto Lab. Paul is IBM DB2 UDB Certified, a Redhat Linux Certified Engineer (RHCE) as well as a SUN Certified Java 2 Programmer. He has significant hands-on experience with DB2 SQL Procedure Language (SQL PL) through work with IBM business partners and customers since its introduction in DB2 Version 7.1.

Bibliographic information