DB2 SQL PL
DB2 SQL PL
Summary
A guide to writing DB2 SQL PL stored procedures, triggers, UDFs, and dynamic compound SQL. It covers everything from basic program structure through advanced techniques and includes coverage of optimization and troubleshooting. It shows developers how to take advantage of various facets of the SQL PL language and development environment.
The feel-good place to buy books
- Free US shipping over $15
- Buying preloved emits 41% less CO2 than new
- Millions of affordable books
- Give your books a new home - sell them back to us!

DB2 SQL PL by Zamil Janmohamed
This new edition covers the DB2 SQL Procedural language (PL) improvementsthat will be introduced as part DB2 8.2. In addition to updates in coverage forLinux, Unix and Windows, there is upside for those working on i-Series and z-Series, where SQL PL functionality did not reside prior to 8.1. In addition toimprovements, 8.2 introduces a method for resolving performance issues, i.e.how to monitor and identify bottlenecks and provide alternatives forresolution. This new book will cover ANY platform! This book teaches thereader how to setup the development environment and use all languageelements of SQL PL through concrete examples and thorough discussions ofXML, SQL procedures, stored procedures, and triggers. Also included areexpert tips and best-practices for achieving optimal performance and codemanageability. This book will be a valuable reference for SQL PL code syntaxand troubleshooting.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.
| SKU | Unavailable |
| ISBN 13 | 9780131477001 |
| ISBN 10 | 0131477005 |
| Title | DB2 SQL PL |
| Author | Zamil Janmohamed |
| Condition | Unavailable |
| Publisher | Pearson Education (US) |
| Year published | 2004-11-25 |
| Number of pages | 576 |
| Cover note | Book picture is for illustrative purposes only, actual binding, cover or edition may vary. |
| Note | Unavailable |