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)
