MVSFORUMS.com

[satjag]

Hello all,

This may be a trivial question , but here goes....

When we use a cursor - if a negative sql code results and error handling is done, will a subsequent " close cursor " work ? For eg:, suppose the sqlcode -904 is handled and the flow is continuing, will a close cursor following the fetch statement work out ?

Thanks in advance,
_________________
Regards,
satjag

[satjag]

Thanks for the answer.
The control will come to FETCH only after the OPEN statement on the cursor is successful.The sequence is OPEN, FETCH and CLOSE. Here if the FETCH is giving the code which I mentioned , will the subsequent CLOSE of the cursor return any sqlcode ?

Thanks in advance,
_________________
Regards,
satjag