MIDRANGE dot COM Mailing List Archive


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