DB2 SQL-Error: -248
SQLState: 24521
Short Description: A POSITIONED DELETE OR UPDATE STATEMENT FOR CURSOR SPECIFIED ROW OF A ROWSET BUT THE ROW IS NOT CONTAINED WITHIN THE CURRENT ROWSET
The FOR ROW n OF ROWSET clause was specified on a positioned DELETE or UPDATE statement, but row n is not contained within the bound of the rowset. This situation can also occur when row n is within the bounds of the rowset that was requested, but the current rowset contains less than the requested number of rows. In this case, a partial rowset is returned. A partial rowset can occur for various reasons, including an end of data condition or an error that did not result in the closure of the cursor. System action: The statement cannot be processed. Programmer response: Reissue the positioned UPDATE or DELETE with a value that corresponds to a row of the current rowset. If the row that is specified is outside of the current rowset, then do the following: v Use the FOR n ROWS clause on a FETCH CURRENT ROWSET statement to specify that the rowset contains a larger number of rows v Reissue the positioned UPDATE or DELETE statement.If this message is issued because a partial rowset was returned, v Update the application logic to detect that the actual rowset size was less than the rowset size that was requested v Ensure that a positioned UPDATE or DELETE statement only refers to rows of the current rowset.