From Jonathan Ball@21:1/5 to All on Tue May 7 15:56:12 2019
I have a SQLRPGLE program with SQL in both the mainline and an internal
(not exported) procedure. When I check SQLSTATE in the mainline, the value reflects the result of the last SQL operation. In the procedure, it is not being updated. None of the SQLCA elements are updated for SQL in the procedure.
Is there a hidden trick to make the SQLCA elements work in a procedure?