Re: CL & SQL

One ideal way is to call an SQLRPGLE program to run the SQL and return the
variable wanted.  I had a developer here who did that.  Initially they
wanted to do it without using an extra program in their CL.  My argument
was that any option would be using another program.  Any CL command
executes a program and therefore you are using another program.  The only
difference is whether you, or someone else, writes the program.

Rob Berendt

==================
Remember the Cole!


                                                                                
                                         
                    "Buzz Fenner"                                               
                                         
                    <bfenner@jonesboroc        To:     "Midrange Discussion" 
<Midrange-L@midrange.com>                   
                    wl.org>                    cc:                              
                                         
                    Sent by:                   Subject:     CL & SQL            
                                         
                    owner-midrange-l@mi                                         
                                         
                    drange.com                                                  
                                         
                                                                                
                                         
                                                                                
                                         
                    05/08/01 04:43 PM                                           
                                         
                    Please respond to                                           
                                         
                    MIDRANGE-L                                                  
                                         
                                                                                
                                         
                                                                                
                                         




Hi All,

I'm new to imbedded SQL.  Can SQL statements be executed from within a CL
program and if so, what resource should I be looking for to guide me in how
to do it.  Thanks.

Buzz Fenner
mailto:bfenner@jonesborocwl.org




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



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