DB2 SQL-Error: -20125
SQLState: 560B3
Short Description: CALL TO STORED PROCEDURE FAILED BECAUSE THE RESULT SET FOR CURSOR IS SCROLLABLE BUT THE CLIENT DOES NOT SUPPORT THIS
A scrollable result set for cursor cursor has been returned by a CALL for stored procedure procedure, but the client is downlevel and does not support scrollable cursors. The DRDA Application Requestor is not able to process scrollable result sets. System action: The statement cannot be processed. All result set cursors that are defined in the stored procedure were closed before returning to the caller. The scrollable cursor cannot be used to FETCH from the result set. Actions that were completed by the stored procedure are not rolled back, and any actions that were initiated by the stored procedure have completed because the error was detected at the end of the execution of the stored procedure. Programmer response: Modify the content of stored procedure procedure to not define result set cursors as scrollable.