MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » July 2008

Re: SQL in REXX



fixed

Unless the SQL environment is established on the STRREXPRC, then that must be done in the REXX before using EXECSQL. The noted failure is due to the request being forwarded to *COMMAND environment processing, instead of to *EXECSQL; i.e. a CPF0001 is a command invocation failure.

Precede the failing request with:
address "*EXECSQL"

By setting the *EXECSQL environment explicitly [on the prior or the same line as the EXECSQL request], then that is established irrespective of what is specified on the STRREXPRC command invocation. See also:
http://archive.midrange.com/midrange-l/200804/msg00305.html
http://archive.midrange.com/midrange-l/200804/msg00218.html

Regards, Chuck

David FOXWELL wrote:

It's not working for me though :

When I execute, I get :
EXECSQL 'SET TRANSACTION ISOLATION LEVEL NO COMMIT';
RC(CPF0001)





Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot 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 here. If you have questions about this, please contact