RE: RUNSQLSTM - included with v4? not v3?

[Buck Calabro <buck.calabro@xxxxxxxxxxxxxxxxx>]

David Shea wrote:

>I have a procedure that uses RUNSQLSTM on my v4r4 box.  In trying to run it
>on a v3r2 box, I learned that his box doesn't have the RUNSQLSTM command.
>It appears that on v3 it was part of SQL/400 licensed product.  I'm not
sure
>on the v4 box if the same is true.
-snip-
>Is there any alternative way to do a RUNSQLSTM type process on a box
without
>RUNSQLSTM?

Yes, use QMQRY.  Search the IBM manuals for Query Management Query.  Very
basically, you put SQL source in a source file (QQMQRYSRC) and then
"compile" it via CRTQMQRY.  An example:

SELECT SYS_DNAME,SYS_TNAME,SYS_CNAME
FROM SYSCOLUMNS                     
WHERE NAME LIKE &SEARCH             
ORDER BY 3,1,2                      

When you execute this via STRQMQRY you can either supply the value for
"SEARCH" or let the prompter ask you for it:  

strqmqry syscolqm setvar((search '''NAME'''))  

Buck Calabro
Aptis; Albany, NY
"Nothing is so firmly believed as
 that which we least know" -- Michel Montaigne
Visit the Midrange archives at http://www.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
+---