• RRP: £50.17
  • You Save: £1.36 (3%)
FREE Delivery in the UK.
Temporarily out of stock.
Order now and we'll deliver when available. We'll e-mail you with an estimated delivery date as soon as we have more information. Your account will only be charged when we dispatch the item.
Dispatched from and sold by Amazon.
Gift-wrap available.
DB2 SQL PL: Essential Gui... has been added to your Basket
Have one to sell?
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See all 2 images

DB2 SQL PL: Essential Guide for DB2 UDB on Linux, Unix, Windows, i5/os, and Z/os Paperback – 15 Nov 2004

See all 2 formats and editions Hide other formats and editions
Amazon Price New from Used from
"Please retry"
£48.81 £38.95
£48.81 FREE Delivery in the UK. Temporarily out of stock. Order now and we'll deliver when available. We'll e-mail you with an estimated delivery date as soon as we have more information. Your account will only be charged when we dispatch the item. Dispatched from and sold by Amazon. Gift-wrap available.

Product details

More About the Author

Discover books, learn about writers, and more.

Product Description

From the Back Cover

  • 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 the IBM DB2 SQL Procedural Language (SQL PL), programmers can drive major improvements in database performance, manageability, and time-to-market. Now, IBM's own experts present the definitive guide to DB2 SQL PL development on any platform: Windows, UNIX, Linux, iSeries, or zSeries.

DB2 SQL PL, Second Edition shows developers how to take advantage of every facet of the SQL PL language and development environment. The authors offer up-to-the-minute coverage, best practices, and tips for building basic SQL procedures, writing flow-of-control statements, creating cursors, handling conditions, and much more. Along the way, they illuminate advanced features ranging from stored procedures and triggers to user-defined functions.

The only book to combine practical SQL PL tutorials and a detailed syntax reference, DB2 SQL PL, Second Edition draws on the authors' unparalleled expertise with SQL PL in real business environments. Coverage includes

  • 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

Whether you're developing new SQL PL applications, migrating or tuning existing applications, or administering DB2, you'll find this bookindispensable.

About the Author

Clara Liu, Fraser McAuthur, Michael Gao, Paul Yip, and Raul Chong are consultants from the Information Management Services at the IBM Toronto Laboratory. They work closely with the IBM DB2 development team and have extensive hands-on experience with the DB2 SQL Procedural Language (SQL PL) through their work with IBM business partners and customers.

Drew Bradstock is the Product Manager for DB2 for Linux, UNIX and Windows. He works with all of DB2’s customers, users, developers and champions to ensure that each release exceeds customers’ expectations. Drew has been a speaker at numerous conferences, a Redbook author and is always looking for feedback on DB2.

Zamil Janmohamed is a Websphere Commerce development manager at the IBM Toronto Lab. He manages a team focused on developer productivity and tooling for Websphere Commerce practitioners. He also has an extensive background working with relational databases, not only as it relates to developing applications, but also designing, implementing, and supporting databases.

Customer Reviews

There are no customer reviews yet on Amazon.co.uk.
5 star
4 star
3 star
2 star
1 star

Most Helpful Customer Reviews on Amazon.com (beta)

Amazon.com: 10 reviews
10 of 11 people found the following review helpful
embed yourself in db2 26 Dec. 2004
By W Boudville - Published on Amazon.com
Format: Hardcover
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.
3 of 4 people found the following review helpful
A very good book on DB2 SQL PL 24 Jan. 2006
By Omaha, NE - Published on Amazon.com
Format: Hardcover
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.
2 of 3 people found the following review helpful
Everything that's bad about IBM 17 Mar. 2010
By Peter H - Published on Amazon.com
Format: Hardcover Verified Purchase
This is so typically IBM - a total lack of appreciation of the needs of the reader leading to a book that may well contain the information, but makes it near-impossible to find or use. This was a bad book before they updated it and merged in all three major platforms, but now it's just vile - big blocks of platform-specific material that you have to skip past make it a real chore to read.

The grammar is poor - if this book had a professional editor, they should be deeply ashamed. Much of the content is warmed-over material from the (also poor) official reference materials, and there is no real narrative structure. Finally, even the indexing is weak.

Don't waste your money - the online reference books have all the material, and Google will find you more helpful explanatory material.
PL/SQL reference - FANTASTIC 29 Jan. 2012
By Robert Pyles - Published on Amazon.com
Format: Hardcover Verified Purchase
This is a FANTASTIC PL/SQL reference text for coding needs in the z/OS schema. LUW and iSeries are also documented. Examples are provided for every topic presented. The hardback cover was ordered and the paperback cover returned to ensure the broad utilization of the book would allow for a longer time frame. Multiple team members on the project team utilize this book for reference needs.

I would give it a 10 star rating is it were available!!
Great tutorial on DB2 stored procedures, triggers, and UDFs 31 Oct. 2009
By Sir Not Appearing in this Review - Published on Amazon.com
Format: Hardcover Verified Purchase
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.
Were these reviews helpful? Let us know