Re: RUNSQLSTM - included with v4? not v3?

David
            Years back NEWS400 published a utility for doing this .  It
made use of the standard query tools to extract the SQL functionality iut
the the DB400 database. I have been using it for years and  if you  email
me offline I could send you a copy of the source .


Michael Kenney
IT Services
University of Windsor
kenney@uwindsor.ca


                                                                                
                                         
                    "Shea, David"                                               
                                         
                    <DShea@arctools.com        To:     
"'midrange-l@midrange.com'" <midrange-l@midrange.com>             
                    >                          cc:                              
                                         
                    Sent by:                   Subject:     RUNSQLSTM - 
included with v4? not v3?                        
                    owner-midrange-l@mi                                         
                                         
                    drange.com                                                  
                                         
                                                                                
                                         
                                                                                
                                         
                    01/04/2001 09:54 AM                                         
                                         
                    Please respond to                                           
                                         
                    MIDRANGE-L                                                  
                                         
                                                                                
                                         
                                                                                
                                         




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.

I have a vague recollection that SQL is bundled with v4 but I'm not sure.

Making things more confusing is my other vague recollection that you can
run
SQL type activities on this v3r2 box using something like a Rumba or other
ODBC product, but can't run it from a command line.   Hmmmmm.

Can anyone fill me in on whether RUNSQLSTM is bundled and if so, as of what
release?

Is there any alternative way to do a RUNSQLSTM type process on a box
without
RUNSQLSTM?

Thanks.





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