Re: SQL from CL

Kind of.

You can use statements without host variables.
You can pass host variables directly to an SQL statement.
You cannot retrieve host variables directly from an SQL statement.

A common way to execute SQL from within CL is to use Query Management
Query.  This does not require the SQL licensed program.  However the SQL
licensed program does add a nice prompter to it.

We've used the above technique to give us a nice command called RUNSQL to
use from CL.  Actually we got it out of an ancient issue of News/400.
Member creation date of source is 10/91.  Consists of three objects created
with the following commands:  CRTCMD, CRTCLPGM and CRTQMQRY.

Give us your problem/statement.  We'll fix you right up.

For further information on Query Management, check out:
http://publib.boulder.ibm.com/pubs/html/as400/v4r5/ic2924/info/db2/rbaromst02.htm


Rob Berendt

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


                                                                                
                                       
                    "Anna Matasyan"                                             
                                       
                    <Amatasyan@frankf        To:     <RPG400-L@midrange.com>    
                                       
                    elix.com>                cc:                                
                                       
                    Sent by:                 Subject:     SQL from CL           
                                       
                    owner-rpg400-l@mi                                           
                                       
                    drange.com                                                  
                                       
                                                                                
                                       
                                                                                
                                       
                    11/15/00 11:45 AM                                           
                                       
                    Please respond to                                           
                                       
                    RPG400-L                                                    
                                       
                                                                                
                                       
                                                                                
                                       





Is there a way to call a SQL statement from   CL?
Thanks.



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