Hi Phani,
     
     Check out the Query management manuals.
     
     Query management allows you to define a SQL statement in a source 
     member, the statement may have Variables and once compiles it becomes 
     an executable SQL statement (Very flexible and easy to set up).
     
     Your problem may be solved by creating using 2 query management 
     queries. Contact me direct if you have any problems setting this up. 
     If you want to solve the Journaling error I'd need more info on what 
     you are trying to do.
     
     
     Regards,
     
     Frank Meaney
     (Unisoft Systems Ltd)
     Email : Frank.Meaney@Unisoft.ie


______________________________ Reply Separator _________________________________
Subject: execute SQL statements through a CL program 
Author:  <MIDRANGE-L@midrange.com> at NPB-INTERNET-MAIL
Date:    5/13/98 4:28 AM


     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?
     
     Also, we want to be able to execute multiple SQL statements from the 
     same SQL source. Is this possible? How can we do this?
     
     Best regards,
     Phani
     
+---
| 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 
+---
     


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


This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].