RE: SQL TRICKS & TECHNIQUES FOR iSERIES book & cd-rom

[Vern Hamberg <vhamberg@xxxxxxxxxxxxxxxxxxxxxxxxx>]

I agree there have been many changes. But basic SQL and the various 
techniques are likely to be fully usable. If you're fairly new to SQL, you 
have to start somewhere. Conte's "old" book is still helpful. Even stuff 
from other platforms is useful, because the differences are minor when 
platform-specific functions are not involved.

Syntactically, everything is the same in later releases. The new stuff is 
enhancements and things that make life a little easier. I'd say that with a 
base in V5R1, getting to the new stuff is fairly easy - it is 
well-documented in the SQL manuals under What's New - probably as well done 
as anything in this area for the new stuff.

I also have not looked at this book.

JMHO
Vern

At 10:15 AM 7/22/2004, you wrote:
> > -----Original Message-----
> > From: midrange-l-bounces@xxxxxxxxxxxx / Smith, Dave
> > Sent: Thursday, July 22, 2004 10:45 AM
> >
> > Dan:
> >
> > No experience with it but it looks like it was written based on V5R1
> > looking at the sample index.  There have been so many changes with SQL
> > in V5R2 and V5R3 that I would think twice about it.   Based on the
> > authors, I'm sure it's an excellent book but you may want to see if
> > there is a new release due out soon.
> >
> > It seems like every time I buy a book the "new" edition comes out a week
> > later.
> >
> > David J. Smith
> > IT Contractor
> > dsmith@xxxxxxxxx
> > 517.546.5400 Ext: 1513
>
> Hi Dave!
>
> Yeah, that's what we want to avoid as well.  It does mention "SQL
> enhancement set for DB2 with V5R2" at the very bottom of the index, which
> may be a Q&D addendum.
>
> Might check it out anyway, they allow returns if not satisfied.
>
> db