logo  
Google
 

DB2 SQL-Error: -249

SQLState: 24523

Short Description: DEFINITION OF ROWSET ACCESS FOR CURSOR IS INCONSISTENT WITH THE FETCH ORIENTATION CLAUSE SPECIFIED C E SQL NEXT PRIOR FIRST LAST CURRENT ABSOLUTE RELATIVE A WITH ROWSET POSITIONING BEFORE AFTER NEXT ROWSET PRIOR ROWSET FIRST ROWSET LAST ROWSET CURRENT ROWSET ROWSET STARTING AT NEXT PRIOR FIRST LAST CURRENT ABSOLUTE RELATIVEA FOR ROWS FETCH S T P C FOR ROWS

A clause specified for the FETCH statement is inconsistent with the definition of the cursor cursor-name. This error can be issued for the following situations: v A cursor defined WITHOUT ROWSET POSITIONING can only use BEFORE, AFTER, row

 <-  BACK TO INDEX