Re: Ques on SQL statement run from CL

[Scott.Lindstrom@xxxxxxxxxx]

I realized shortly after I posted this that the SELECT didn't work.  But if
you need to do a DELETE, UPDATE, etc this sample works fine.

Scott Lindstrom


                                                                                
                 
                    DonW400@aol.com                                             
                 
                    Sent by:                   To:     
<MIDRANGE-L@midrange.com>                 
                    owner-midrange-l@mi        cc:                              
                 
                    drange.com                 Subject:     Re: Ques on SQL 
statement run from   
                                               CL                               
                 
                                                                                
                 
                    10/12/2000 01:00 PM                                         
                 
                    Please respond to                                           
                 
                    MIDRANGE-L                                                  
                 
                                                                                
                 
                                                                                
                 




   I don't believe that RUNSQLSTM will accept a SELECT.
   What I normally use is a "dummy" *QMQRY that accepts a bunch (I use 8)
parameters.
   Marie, I'll send some sample code to by e-mail if you want it.
Don Whittaker

==============================================

In a message dated Wed, 11 Oct 2000  5:39:20 PM Eastern Daylight Time,
Scott.Lindstrom@zenith.com writes:

<<
How about this:

RUNSQLSTM  SRCFILE(library/SQLSRC) SRCMBR(CHKLVLCHK) +
             COMMIT(*NONE) OUTPUT(*PRINT)

SQLSRC member:

SELECT WHLIB, WHPNAM, WHFNAM, WHRFSN, rffile, rflib, rfid
from qtemp/pgms inner join qtemp/files
on whfnam = rffile
where whrfsn <> rfid;

Scott Lindstrom
Zenith Electronics



                    "Graziano, Marie"
                    <mgraziano@badgerme        To:     "'Midrange'"
<MIDRANGE-L@midrange.com>
                    ter.com>                   cc:
                    Sent by:                   Subject:     Ques on SQL
statement run from CL
                    owner-midrange-l@mi
                    drange.com


                    10/11/2000 02:52 PM
                    Please respond to
                    MIDRANGE-L






If I save an interactive sql in a file and then want to have a cl execute
the code .
 It does someone have a sample.  I know I can use outside tools, I really
do
not want to make this an EMAIL war, just
A short yes or no.,

Do I have to use open qry file is what this is all about, I would prefer
not
to.
Marie Graziano





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



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