RE: Recommendation for a good iSeries SQL reference? -- MIDRANGE-L

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

The SQL for Smarties book is by Joe Celko, who has been on thestandards committee for SQL-89 and SQL-92, I believe. I found hisbook extremely enlightening, esp. in this heterogeneous world ofdatabases. Celko has a good understanding of the differences betweenvarious implementations and can help understand why results aredifferent from one system to another. It's not necessarily for thebeginner, and not everything he suggests can be done on the iSeries(yet, for some things). He has another book called "SQL Puzzles andAnswers" and has been a columnist in several DB magazines - ofcourse, 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 agoogle 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.