Re: Recommendation for a good iSeries SQL reference?

[Vernon Hamberg <vhamberg@xxxxxxxxxxx>]

I agree, Colin. After all, it's a reference, not a how-to. As someone 
else said, SQL is the same, essentially, no matter what platform. And 
there are only a few things we use all the time - SELECT for sure, 
DELETE/INSERT/UPDATE less so, then various CREATEs. These all (not 
CREATEs) use the WHERE clause. Anything after that is gravy. For 
SELECTs learn to use GROUP BY/HAVING/ORDER BY and you have almost 
everything you need. And the reference is where to learn what scalar 
and column functions you can use. No need for greater detail than 
what is there, IMO.

Now, for how-tos, we have to dig a little. There're the host language 
programming books, for functions and stored procedures, etc., there 
are separate manuals and redbooks.

After a while, what you do is up to your imagination. Just like 
everything else we do. The link I gave to the DB2 site is good. And 
any SQL tutorial on the web will help.

Finally, consider the books by Joe Celko (sp?). One is "SQL for Smarties".

Vern

At 04:52 AM 12/15/2005, you wrote:

> Am I the only one that thinks the IBM Iseries SQL Reference is very good.
>
> It doesnt have a huge amount of examples, but generally if I read that I can
> figure most things out
>
>
> On 14/12/05, vhamberg@xxxxxxxxxxx <vhamberg@xxxxxxxxxxx> wrote:
> >
> > Jim, you might take a look at
> >
> > www.iseries.ibm.com/db2
> >
> > and dig around. There is a lot of technical stuff, examples, etc., there.
> >
> > Vern
> >
> > -------------- Original message --------------
> > From: "Jim Franz" <franz400@xxxxxxxxxxxx>
> >
> > > Walden,
> > >
> > > I generally work in sites that have a mixture of old & new stuff. So
> > > having to do something as trivial (to me) as a select statement for a
> > > specific
> > > member in a file, which is very AS400/iSeries specific, I think should
> > be a
> > > part of every "iSeries" sql book.... it's not... One book mentioned you
> > can
> > > read members, but gave no example... There are many other examples I
> > > could give.
> > > In some books, trying to do more than a single file selection is not
> > > explained - examples are "Hello World" kind of cr*p - too simplistic
> > > for a working programmer.
> > > jim franz
> > > ----- Original Message -----
> > > From: "Walden H. Leverich"
> > > To: "Midrange Systems Technical Discussion"
> > > Sent: Wednesday, December 14, 2005 8:53 AM
> > > Subject: RE: Recommendation for a good iSeries SQL reference?
> > >
> > >
> > > > >Some real basic stuff is just missing from the examples.
> > > >
> > > > Jim,
> > > >
> > > > Are you speaking of basic SQL stuff, or basic stuff about integrating
> > > > SQL w/RPG or Cobol? If it's basic SQL stuff (select, where, join,
> > group
> > > > by etc.) have you considered that SQL is a standard, especially with
> > the
> > > > basic stuff, and just about any book on SQL (iSeries specific or not)
> > > > will get you what you need?
> > > >
> > > > -Walden
> > > >
> > > > ------------
> > > > Walden H Leverich III
> > > > Tech Software
> > > > (516) 627-3800 x3051
> > > > WaldenL@xxxxxxxxxxxxxxx
> > > > http://www.TechSoftInc.com
> > > >
> > > > Quiquid latine dictum sit altum viditur.
> > > > (Whatever is said in Latin seems profound.)
> > > >
> > > >
> > > > --
> > > > 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.
> >
> >
> --
> 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.