× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. July 2004

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

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



As an Amazon Associate we earn from qualifying purchases.

This thread ...
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.