DB2 SQL Procedure Language for Linux, Unix and Windows - Softcover

Yip, Paul; Bradstock, Drew; Curtis, Hana; Gao, Michael; Janmohamed, Zamil; Liu, Clara; McArthur, Fraser

9780131007727: DB2 SQL Procedure Language for Linux, Unix and Windows

Softcover

ISBN 10: 0131007726 ISBN 13: 9780131007727

Publisher: IBM Press, 2002

Covers all language elements of DB2 SQL procedure language with an abundance of examples and detailed explanations. Includes expert tips and best practices derived from experiences with real customers. From the specialists at the IBM Toronto Lab.

"synopsis" may belong to another edition of this title.

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.

Synopsis:

SQL Procedure Language (SQL PL) is used in DB2 to write database-stored procedures. Stored procedures are used to encapsulate business logic on the database and yield the following benefits: significantly improved application performance, increased application scalability, simplified application development, and reduced network traffic. This book will teach the reader how to set up the development environment and use all language elements of SQL PL through concrete examples and thorough discussions. Also included are expert tips and best practices for achieving optimal performance and code manageability. This book will be a valuable reference for SQL PL code syntax and troubleshooting. There are currently no books on the market that cover the DB2 SQL Procedure Language, although it is extensively used by IBM business partners and other software vendors.

"About this title" may belong to another edition of this title.