DB2(R) SQL Procedure Language for Linux, UNIX and Windows (IBM DB2 Certification Guide Series) | 
 enlarge | Authors: Paul Yip, Drew Bradstock, Hana Curtis, Michael Gao, Zamil Janmohamed, Clara Liu, Fraser Mcarthur
Publisher: Prentice Hall PTR
Category: Book
List Price: $59.99
Buy New: $43.99
You Save: $16.00 (27%)
New (3) Used (8) from $18.30
Avg. Customer Rating:  11 reviews
Sales Rank: 936588
Media: Paperback
Number Of Items: 1
Pages: 352
Shipping Weight (lbs): 1.5
Dimensions (in): 9.3 x 7 x 1
ISBN: 0131007726
Dewey Decimal Number: 005.133
UPC: 076092021452
EAN: 9780131007727
ASIN: 0131007726
Publication Date: December 24, 2002
Availability: Usually ships in 1-2 business days
Shipping: Expedited shipping available
Shipping: International shipping available
|
| Also Available In:
|
| Similar Items:
|
| Editorial Reviews:
Product Description
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.
|
| Customer Reviews: Read 6 more reviews...
iF YOU WANT TO GO DEEPER IN SPL November 6, 2006
It is really a very good book from IBM about DB2-SPL. In our company we bougth a lot of DB2 book, but this is the very best.
from basics to tricks
DB2(R) SQL PL: Essential Guide for DB2(R) UDB on Linux(TM), UNIX(R), Windows(TM), i5/OS(TM), and z/OS(R) (2nd Edition September 16, 2006
Has been extremely helpful. Good information
A very good book on DB2 SQL PL January 25, 2006
2 out of 3 found this review helpful
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.
 embed yourself in db2 December 27, 2004
9 out of 10 found this review helpful
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.
Excellent book for developers/DBAs new to DB2 October 23, 2004
17 out of 18 found this review helpful
If you are a developer or DBA who is new to DB2, I would highly recommend this book to you. Both administration and development topics are covered, helpful best practices and tips are included, and illustrative examples are used.
The fundamental DB2 concepts and the different DB2 tools such as the Control Center are introduced in a very straightforward and easy-to-understand manner. This allows DB2-newbies to get fully up to speed on DB2 terminology and functionality, while serving as a gentle refresher for those who might have prior DB2 experience. The book achieves a good balance of topic selection and level of detail. More advance topics that are covered are explained in a manner that most novices would comprehend and in enough detail to be useful.
The prime focus of the book is on leveraging the ease-of-use and autonomic capabilities of DB2. If you are a developer not wanting to memorize database and/or SQL command syntax, you will particularly appreciate this book. The book shows how most common administrative tasks can be very easily performed using the GUI tools and Wizards provided with DB2. Ease of application development is demonstrated in both Java and Microsoft .net environments. An easy and intuitive introduction to DB2 SQLPL is also provided.
Overall, I think that if you are new to DB2, or need to learn the essential concepts/features needed to develop and/or administer DB2 quickly, you will be very pleased with this book. It is a perfect starting point for introducing the most important concepts, features, and tools. As you gain more experience and familiarity with the product, a more advanced book can be obtained.
|
|
|
