RE: Call Query

["Cobb, Laura" <LCobb@xxxxxxxxxxxxx>]

Excellent...
I have been waiting for some insight on embedded SQL.  I have read James
Coolbaugh's "Desktop Guide to SQL" and see how powerful and useful this tool
could be.  I say could be because I wouldn't know where to start.
So if we take Jose's program need as a beta scenario, how would this be done
using embedded SQL?
The solution I would consider for Jose's situation would be the online RPG
passing the parms to a CL run the query from the CL.  If this sounds awful,
it is probably due in part to my short time as a programmer.
Would you be kind enough to tell me where and how to embed the SQL as well
as any pertinent considerations.
In house there aren't any programs currently that use embedded SQL so I
don't have any starting ground.  Often when discussing homegrown
applications needs with the senior programmers I think to myself that this
program may be better written with embedded SQL, but without someone who
knows SQL to turn to it simply remains a thought.
Regards,
 L.A.C.




                -----Original Message-----
                From:   Bob Slaney/Atlanta/IBM [mailto:rjslaney@us.ibm.com]
                Sent:   Friday, October 20, 2000 12:44 PM
                To:     RPG400-L@midrange.com
                Subject:        Re: Call Query

                Perfect application for embedded SQL with a dynamic SELECT.
Just my two
                cents.

                Bob

                Bob Slaney/Atlanta/IBM @ IBMUS (Lotus Notes)
                VM id: WTSCPOK.RJSLANEY@VM
                Internet id: rjslaney@us.ibm.com
                Tieline 596-3022 Direct (770)835-3022
                Fax tie 596-3912 Direct (770)835-3912

                IBM Learning Services
                AS/400 Course Materials Development
                IBM Corp.
                3100 Windy Hill Road
                Atlanta, GA 30339
                Internal Zip WE3A1

                +---
                | This is the RPG/400 Mailing List!
                | To submit a new message, send your mail to
RPG400-L@midrange.com.
                | To subscribe to this list send email to
RPG400-L-SUB@midrange.com.
                | To unsubscribe from this list send email to
RPG400-L-UNSUB@midrange.com.
                | Questions should be directed to the list owner/operator:
david@midrange.com
                +---
+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---