DB2 SQL PL: Essential Guide for DB2 UDB on Linux, UNIX, Windows, i5/OS and z/OS / Edition 2

Paperback (Print)
Used and New from Other Sellers
Used and New from Other Sellers
from $1.99
Usually ships in 1-2 business days
(Save 97%)
Other sellers (Paperback)
  • All (9) from $1.99   
  • New (4) from $10.56   
  • Used (5) from $1.99   
Sort by
Page 1 of 1
Showing All
Note: Marketplace items are not eligible for any BN.com coupons and promotions
Seller since 2009

Feedback rating:



New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.

Brand New! Includes CD-ROM! Ships same day or next business day. Free USPS Tracking Number. Excellent Customer Service. Ships from TN

Ships from: Nashville, TN

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
Seller since 2014

Feedback rating:


Condition: New
Brand New Item.

Ships from: Chatham, NJ

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
Seller since 2014

Feedback rating:


Condition: New
Brand new.

Ships from: acton, MA

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
Seller since 2014

Feedback rating:


Condition: New
Brand new.

Ships from: acton, MA

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
Page 1 of 1
Showing All
Sort by


  • 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 book indispensable.

Read More Show Less

Product Details

  • ISBN-13: 9780131477001
  • Publisher: IBM Press
  • Publication date: 9/11/2004
  • Edition description: REV
  • Edition number: 2
  • Pages: 550
  • Product dimensions: 7.20 (w) x 9.54 (h) x 1.35 (d)

Meet 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.

Read More Show Less

Table of Contents

Ch. 1 Introduction 1
Ch. 2 Basic SQL procedure structure 11
Ch. 3 Overview of SQL PL language elements 37
Ch. 4 Using flow of control statements 63
Ch. 5 Understanding and using cursors and result sets 93
Ch. 6 Condition handling 125
Ch. 7 Working with dynamic SQL 175
Ch. 8 Nested SQL procedures 193
Ch. 9 User-defined functions and triggers 215
Ch. 10 Leveraging DB2 application development features 271
Ch. 11 Deploying SQL procedures, functions, and triggers 299
Ch. 12 Performance tuning 325
Ch. 13 Best practices 355
App. A Getting started with DB2 371
App. B Inline SQL PL for DB2 UDB for Linux, UNIX, and Windows 411
App. C Building from the command line 419
App. D Using the DB2 development center 431
App. E Security considerations in SQL procedures 463
App. F DDL 473
Read More Show Less



The more things change, the more they stay the same.

Last year, when the first edition of this book was released, IBM had just released an updated version of DB2 on the Linux, UNIX, and Windows platforms—a version that was the most significant release to date, and one that provided new capabilities to reflect advances in the technology of both database systems and IT in general.

As I write this only a year later, IBM has once again just released an updated versions of the DB2 UDB product family; DB2 UDB for Linux, UNIX, and Windows, DB2 UDB for iSeries and DB2 UDB for zSeries—significant new releases that include many new features and enhancements that make this the most advanced set of database products IBM has ever offered—and we believe the most advanced in the industry.

Unlike the first edition of the book, which covered only the Linux, UNIX, and Windows platforms, the second edition of this book covers SQL Procedural Language for the entire DB2 family—those platforms covered in the first edition, and now including DB2 for z-Series (OS/390) and i-Series (i5/OS) platforms. Additionally, this edition introduces a method for resolving performance issues—how to monitor and identify bottlenecks, and how to provide alternatives for resolution.

DB2 UDB is evolving to reflect the changing needs of the development community. Many of the new features in DB2 UDB are designed to significantly improve ease of use for the development community, including new autonomic capabilities than will help to change the role of the DBA. There have been many other areas of technicalleadership that have been introduced in technical support; all have helped to propel DB2 into the leadership position in the database market.

Another such developer-oriented feature is the subject of the original edition of this publication; this updated second edition focuses on the updates and improvements for SQL PL in updated versions of DB2 UDB.

SQL PL for DB2 provides a high-level language to build portable application logic that has the potential for better performance and scalability, by virtue of exploiting server-side resources and eliminating client bottlenecks. Exploiting SQL PL can also serve to improve the manageability and security of applications by providing a more modular structure. The latest version of DB2 UDB on all platforms includes enhancements for stored procedure development that significantly increases usability, allowing more developers to experiment with writing these stored procedures. This updated edition discusses this enhancement in detail.

An important feature in the updated versions of DB2 is that SQL PL is now native in all versions—DB2 UDB is no longer dependent upon translation into C stored procedures. For you as a developer, you'll see increased productivity and faster performance from your applications. And, you'll see reduced costs of ownership—no more additional expenses from compilers or run-times.

Knowing how and when to exploit the many capabilities of SQL PL for DB2 is an important skill to develop—and the authors of this book are experts on the subject, as certified DB2 specialists.

They have done a very nice job in efficiently laying out the many benefits in an easy to understand fashion. They've covered all language elements of DB2 SQL PL, with a large number of examples and detailed explanations. They offer expert tips and best practices derived from experiences with real customers. Nowhere else will the reader find such a vast array of experience-driven tips; this book is the ultimate developer's resource for writing SQL procedures.

We at IBM are very proud of the success that we've seen with DB2, and we're grateful to our many partners, developers and customers who have chosen to build and run their solutions with our database product. Working together, we've built the industry's premiere database product and the broadest set of applications and solutions in the market.

We continue to listen intently to your needs and requirements, and have focused on addressing many of these requirements as DB2 continues to evolve. I know that the skills that you are about to learn or hone for SQL PL for DB2 will serve you well; on behalf of IBM, I look forward to a continuing relationship of delivering the industry's best solutions and applications.

Janet Perna
General Manager, Information Management
IBM Software Group

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star


4 Star


3 Star


2 Star


1 Star


Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation


  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing 1 Customer Reviews
  • Anonymous

    Posted December 26, 2004

    embed yourself in db2

    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.

    Was this review helpful? Yes  No   Report this review
Sort by: Showing 1 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)