Re: Ques on SQL statement run from CL

[Scott.Lindstrom@xxxxxxxxxx]

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