Re: Recommendation for a good iSeries SQL reference?

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