RE: Recommendation for a good iSeries SQL reference?

Vern, I agree, they both had some valid use for learning the fundamentals,
but neither were as applicable to AS400 as I had hoped.  However, the Celko
book actually lives on my bookshelf at work where I can get my hands on it
quickly.  

For me, "The Redbook" offered more of those head slapping moments when
suddenly things make sense.  There wasn't much SQL coverage in there, but
what was there was VERY illuminating.  

Whatever happened to the "Son of Redbook"?  

Eric DeLong
Sally Beauty Company
MIS-Project Manager (BSG)
940-297-2863 or ext. 1863



-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Vernon Hamberg
Sent: Monday, December 19, 2005 10:28 AM
To: Midrange Systems Technical Discussion
Subject: RE: Recommendation for a good iSeries SQL reference?


I don't know the SQL for Dummies book, but although it focuses on SQL 
Server, it probably has some techniques that are helpful.

The SQL for Smarties book is by Joe Celko, who has been on the 
standards committee for SQL-89 and SQL-92, I believe. I found his 
book extremely enlightening, esp. in this heterogeneous world of 
databases. Celko has a good understanding of the differences between 
various implementations and can help understand why results are 
different from one system to another. It's not necessarily for the 
beginner, and not everything he suggests can be done on the iSeries 
(yet, for some things). He has another book called "SQL Puzzles and 
Answers" and has been a columnist in several DB magazines - of 
course, we in the iSeries world have never had to read those, 
right?  ;-)   His site is www.celko.com if you are interested.

In general, I find that anything on SQL can be helpful. So do a 
google on "sql tutorial" and learn everything you can.

HTH
Vern

At 09:53 AM 12/19/2005, you wrote:

>Years ago, when looking for books about SQL, I saw two likely books sitting
>side-by-side;
>
>SQL for Dummies, and SQL for Smarties...  I bought them both, figuring I'm
>bound to be somewhere between the two extremes... <vbg>
>
>Interestingly enough, SQL for Dummies was mostly focused on MS SQL Server
>(ironic, huh?)..
>
>The smarties book used examples from a variety of SQL implementations, but
>was more of a SQL theory primer, and not really practical for iSeries
SQL...
>
>Eric DeLong
>Sally Beauty Company
>MIS-Project Manager (BSG)
>940-297-2863 or ext. 1863
>
>
>
>-----Original Message-----
>From: midrange-l-bounces@xxxxxxxxxxxx
>[mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of rob@xxxxxxxxx
>Sent: Monday, December 19, 2005 9:02 AM
>To: Midrange Systems Technical Discussion
>Subject: Re: Recommendation for a good iSeries SQL reference?
>
>
>I still refer to that on occasion.
>
>Rob Berendt
>--
>Group Dekko Services, LLC
>Dept 01.073
>PO Box 2000
>Dock 108
>6928N 400E
>Kendallville, IN 46755
>http://www.dekko.com
>
>
>
>
>
>Phil Groschwitz <ssc1478@xxxxxxx>
>Sent by: midrange-l-bounces@xxxxxxxxxxxx
>12/17/2005 12:00 PM
>Please respond to
>Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
>
>
>To
>Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
>cc
>
>Fax to
>
>Subject
>Re: Recommendation for a good iSeries SQL reference?
>
>
>
>
>
>
>On Tue, 2005-12-13 at 17:25 -0600, Ron Adams wrote:
> > I'm looking for a good book on iSeries SQL (not the IBM Reference). It
>can
> > be an online guide or something that's in print. Preferrably it will
>contain
> > lots of examples on the use of iSeries SQL.
>
>I used SQL/400 Developer's Guide by Paul Conte.  I found it very useful
>when I was learning how to embed sql.  Now that I know how to do that,
>though, I don't reference it anymore.
>
>Phil
>
>
>
>--
>This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
>list
>To post a message email: MIDRANGE-L@xxxxxxxxxxxx
>To subscribe, unsubscribe, or change list options,
>visit: http://lists.midrange.com/mailman/listinfo/midrange-l
>or email: MIDRANGE-L-request@xxxxxxxxxxxx
>Before posting, please take a moment to review the archives
>at http://archive.midrange.com/midrange-l.
>
>
>--
>This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
>To post a message email: MIDRANGE-L@xxxxxxxxxxxx
>To subscribe, unsubscribe, or change list options,
>visit: http://lists.midrange.com/mailman/listinfo/midrange-l
>or email: MIDRANGE-L-request@xxxxxxxxxxxx
>Before posting, please take a moment to review the archives
>at http://archive.midrange.com/midrange-l.
>
>
>--
>This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
>To post a message email: MIDRANGE-L@xxxxxxxxxxxx
>To subscribe, unsubscribe, or change list options,
>visit: http://lists.midrange.com/mailman/listinfo/midrange-l
>or email: MIDRANGE-L-request@xxxxxxxxxxxx
>Before posting, please take a moment to review the archives
>at http://archive.midrange.com/midrange-l.