RE: SQL Prompts

Cyndi,

If you use embedded sql a lot I think you'll find two things:

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.


> -----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:21 PM
> To: CODE400-L (E-mail)
> Subject: SQL Prompts
>
>
> Ok, we are just starting to use SQL. I just rec'd the ATS SQL
> course and am
> having lots of fun learning what I didn't know. I just did the lesson for
> entering embedded SQL in to an RPG pgm where you press F4 to
> prompt the SQL
> Statement. WOW !!! That's neat !
> However, I am using CODE/400 almost exclusively and tried the same thing
> there...nothing. I checked HELP and it confirmed it. We are at OS/400 V4R4
> and Code V4R5M1 SP2. I do use a STRCODE Session.
> Does Code V5 have prompting for SQL ?  I could push to get it if
> it did. If
> not, is there any plans to add this functionality ? It makes it
> difficult to
> push others to use code when SEU had better functionality.
> TIA,
> Cyndi B.
> Boise, ID
> _______________________________________________
> 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