• IBM's definitive guide to writing DB2 SQL PL stored procedures, triggers, UDFs, and dynamic compound SQL

• Fully updated to reflect the entire DB2 UDB product family, and new SQL PL improvements for Windows, UNIX, Linux, iSeries, and zSeries

• Presents expert tips and best practices drawn from extensive experience in real customer environments

• Covers everything from basic program structure through advanced techniques

• Includes up-to-the-minute coverage of optimization and troubleshooting

• Using SQL PL to improve manageability and performance, while clearly separating DBA and development roles

• Writing more efficient stored procedures, triggers, user-defined functions (UDFs), and dynamic compound SQL

• Identifying SQL PL performance bottlenecks--and resolving them

• Leveraging new language enhancements for Windows, UNIX, and Linux: improved table function support, session based locking, nested save points, new prepare options, and more

• Using new features for iSeries V5R3: built-in string and date/time manipulation functions, SEQUENCE objects, and more

• Utilizing zSeries Version 8's integrated stored procedures debugging and improved SQL Conditions support

• Mastering DB2 Development Center, the unified development environment for creating DB2 stored procedures

Amazon.com® Reader Reviews (Ranked by Helpfulness)

Average Amazon.com® Rating:  Based on 13 Ratings

A very good book on DB2 SQL PL - 2006-01-25
Reviewer Rating:
I didn't know anything about writing DB2 stored procedures until I bought this book. After reading it I have written several procedures to aid in data migration. It is well laid out and has all the necessary information. The best part is that you don't feel like you are reading a technical book.

Great tutorial on DB2 stored procedures, triggers, and UDFs - 2009-10-31
Reviewer Rating:
DB2 SQL PL: The Essential Guide for DB2 is a an excellent tutorial on the topic. This is a must for anyone learning this very important aspect of the DB2 software. The book takes you through a very detailed step by step approach of writing stored procedures with very good examples and very clear explanations. This book will also serve as a good reference.

Very good DB2 PL SQL book - 2009-07-04
Reviewer Rating:
This is a very useful book for people who is going to develop PL SQL procedures. It covers many detail of the DB2 features with many useful samples. I highly recommend it.

iF YOU WANT TO GO DEEPER IN SPL - 2006-11-06
Reviewer Rating:
It is really a very good book from IBM about DB2-SPL. In our company we bougth a lot of DB2 book, but this is the very best.

from basics to tricks

DB2(R) SQL PL: Essential Guide for DB2(R) UDB on Linux(TM), UNIX(R), Windows(TM), i5/OS(TM), and z/OS(R) (2nd Edition - 2006-09-16
Reviewer Rating:
Has been extremely helpful. Good information

Browse Similar Topics

Top Level Categories:
Databases

Sub-Categories:
Databases > DB2