Re: Recommendation for a good iSeries SQL reference?

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.
>
>