• SQLCA elements not working in internal procedure

    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?

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)