Re: SQL from CL

[rob@xxxxxxxxx]

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