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.
Sprache
Verlagsort
Verlagsgruppe
Zielgruppe
Für höhere Schule und Studium
Maße
Höhe: 234 mm
Breite: 178 mm
Dicke: 24 mm
Gewicht
ISBN-13
978-0-13-100772-7 (9780131007727)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Klassifikation
Paul Yip is a member of the core DB2 development team at the IBM Toronto Lab. Paul is IBM DB2 UDB Certified, a Redhat Linux Certified Engineer (RHCE) as well as a SUN Certified Java 2 Programmer. He has significant hands-on experience with DB2 SQL Procedure Language (SQL PL) through work with IBM business partners and customers since its introduction in DB2 Version 7.1.
