Re: execute SQL statements through a CL program

[Chris Rehm <Mr.AS400@xxxxxxx>]

** Reply to message from PhaniHR <PhaniHR@Inf.COM> on Wed, 13 May 1998 04:28:49
-0700

> Hello,
>      
>      A question on the AS/400 query facility. 
>      
>      We need to execute SQL statements through a CL program. When we run 
>      the CL, it gives a journalling error. any idea how to accomplish this?

Unless the files being updated are journaled, you will need to set commitment
control to *none (I'm at home and in a rush so I don't recall the exact setting,
but it is one of the options when running an SQL).

>      
>      Also, we want to be able to execute multiple SQL statements from the 
>      same SQL source. Is this possible? How can we do this?

Hmm, haven't tried. I didn't know it would be a problem. I'll give it a shot
today.

>      Phani



Chris Rehm                                                    
Mr.AS400@ibm.net                                              
                                                              
How often can you afford to be unexpectedly out of business?  
Get an AS/400.                                                
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@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
+---