RE: SQL Prompts

["Bob Cozzi \(RPGIV\)" <cozzi@xxxxxxxxx>]

The book "The SQL Standard" is the only SQL book you really need.
Its about $37 on Amazon.com, here's the URL:

http://www.amazon.com/exec/obidos/ASIN/0201964260/qid=1003346157/sr=2-1/
ref=sr_2_15_1/103-1404539-6047846


Bob Cozzi
cozzi@rpgiv.com
Visit the new on-line iSeries Forums at: http://www.rpgiv.com/forum

> -----Original Message-----
> From: code400-l-admin@midrange.com
[mailto:code400-l-admin@midrange.com] On
> Behalf Of Phil
> Sent: Wednesday, October 17, 2001 2:04 PM
> To: code400-l@midrange.com
> Subject: RE: SQL Prompts
>
> A good book to get started is "SQL/400 Developer's Guide" by Conte &
> Cravitz, 29th Street Press.
>
> You can also use STRSQL at the 400 command line to check syntax.
>
> Phil
>
> > -----Original Message-----
> > From: code400-l-admin@midrange.com
> > [mailto:code400-l-admin@midrange.com]On Behalf Of Cyndi Bradberry
> > Sent: Wednesday, October 17, 2001 2:52 PM
> > To: 'code400-l@midrange.com'
> > Subject: RE: SQL Prompts
> >
> >
> > Thanks Phil,
> > I agree, I adore Code. I have been frustrated because the ATS course
uses
> > SEU and I am inserting lines and trying to TAB to fields.  I haven't
found
> > PREPARE yet, Whoops ! Next chapter !
> > I haven't tried the OPS NAV yet...maybe this afternoon.
> > Cyndi
> >
> > -----Original Message-----
> > From: Phil
> > Subject: RE: SQL Prompts
> > 1. You're going to find you use a host variable (a string) to
> > hold your sql
> > statements (so you can build, and then use PREPARE.  This negates
> > the value
> > of prompting.
> >
> > 2. SQL isn't overly complicated and you'll probably memorize the
> > syntax (in
> > time).  When I don't remember, I use iSQL in OpsNav as an aid.
> >
> > Phil
> >
> > PS: I think Code **as it is** is better than SEU.
> >
> > _______________________________________________
> > This is the CODE/400 Discussion & Support (CODE400-L) mailing list
> > To post a message email: CODE400-L@midrange.com
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/cgi-bin/listinfo/code400-l
> > or email: CODE400-L-request@midrange.com
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/code400-l.
> >
>
>
> _________________________________________________________
> Do You Yahoo!?
> Get your free @yahoo.com address at http://mail.yahoo.com
>
> _______________________________________________
> This is the CODE/400 Discussion & Support (CODE400-L) mailing list
> To post a message email: CODE400-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/code400-l
> or email: CODE400-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/code400-l.