DB2 SQL-Error: -20104
SQLState: 560B1
Short Description: C CANNOT ISSUE SAVEPOINT RELEASE SAVEPOINT ROLLBACK TO SAVEPOINT FROM A TRIGGER FROM A USERDEFINED FUNCTION OR FROM A GLOBAL TRANSACTION CALL TO STORED PROCEDURE FAILED BECAUSE THE RESULT SET RETURNED FOR CURSOR IS SCROLLABLE BUT THE CURSOR IS NOT POSITIONED BEFORE THE FIRST ROW
SAVEPOINT, RELEASE SAVEPOINT, and ROLLBACK TO SAVEPOINT statements can not be used in the body of a trigger or a global transaction. System action: The statement is not executed. Programmer response: Correct the logic of the application program so that this error does not occur. SQLSTATE: 3B503 Explanation: A scrollable result set for cursor cursor has been returned by a CALL to stored procedure procedure, and one or more of these cursors is not positioned before the first row. System action: The Call to the stored procedure was unsuccessful. All result set cursors defined in the stored procedure were closed before returning to the caller. The scrollable cursor can not be used to FETCH from the result set. Actions completed by the stored procedure are not rolled back, and any external actions initiated by the stored procedure have completed because the error was detected upon completion of the stored procedure. Programmer response: Modify the content of the stored procedure to ensure that the result set cursors are positioned before the first row before returning to the caller.