Customer Reviews

1 Review
5 star:    (0)
4 star:
3 star:    (0)
2 star:    (0)
1 star:    (0)
Average Customer Review
Share your thoughts with other customers
Create your own review
Most Helpful First | Newest First

4.0 out of 5 stars detailed explanations of many recipes, 8 May 2012
This review is from: IBM DB2 9.7 Advanced Application Developer Cookbook (Paperback)
I just reviewed the companion IBM DB2 9.7 Advanced Administration Cookbook to the current book. If you are seriously considering the latter, you might also check out the former. The materials in both books are complementary. The present text also presupposes considerable experience with writing long, complex SQL statements.

The 70 recipes offered cover numerous aspects of db2. Some involve the running of a SQL statement dynamically. This reflects the practical reality where you have some large data set and you are cogitating in real time. You have hypotheses that you want to quickly investigate. The text explains that the dynamic SQL statements are not compiled, by definition. Yes, there is a possible or probable loss of optimisation when you can't throw the compiler at it.

The book also shows that you won't get a fancy GUI. Have a gander at the screen captures, such as they are. The input is text. The output is text, and usually lots of it. Where typically you will then iterate over your SQL phrasing to truncate the output to something meaningful to you.

It's worth it if you get this book to quick skim over the recipes, to get a flavour of the breadth of what's available. You probably won't find an exact match to your immediate needs. That's a bit much to expect. But the amount of detailed explanations of each recipe is a good starting point for you to try to take the recipe and alter it for your tasks.

In terms of source code, java snippets are scattered throughout the book. They instruct in how to drive db2 by making SQL statements inside java code and then hooking up to db2 via pre-supplied libraries or classes. A little kludgy perhaps. But that is the reality of interfacing between java and db2.
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No

Most Helpful First | Newest First

This product

IBM DB2 9.7 Advanced Application Developer Cookbook
IBM DB2 9.7 Advanced Application Developer Cookbook by Mohankumar Saraswatipura (Paperback - 14 Mar 2012)
In stock
Add to basket Add to wishlist
Only search this product's reviews