• 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 12 Ratings

embed yourself in db2 - 2004-12-27
Reviewer Rating:
The book describes IBM's Procedural Language, which runs on their db2 servers. It is not a general purpose language, like C or Java. Rather, it is tied directly to db2 and IBM's implementation of SQL. But within this context, the book explains the expressive power of PL. It shows at length how you can write stored procedures, triggers and functions in PL. The level of detail and the cited examples should reassure you of PL's capability.

But why even write business logic code at the database layer? There have been other books on n-tier application design, which call for the locating of business logic in a middle tier and not at the database. The authors' rejoinder is that while that makes for an elegant design, practical experience shows that often, crucial logic needs to be at the database. This reduces networks traffic and can heavily improve perforance. Hence the need for PL, or something like it.

Be wary of the book's claim that PL lets you write "portable application logic". It is portable only between instances of db2 running under linux, unix, Microsoft Windows or IBM's operating systems. When you write embedded logic in PL, you are also embedding yourself or your company into db2. Which may indeed be fine by you. But just so you know.

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.

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