logo  
Google
 

DB2 SQL-Error: -246

SQLState: 42873

Short Description: STATEMENT USING CURSOR SPECIFIED NUMBER OF ROWS WHICH IS NOT VALID WITH

A multiple-row FETCH or multiple-row INSERT statement is not valid in this context. The number of rows that were specified is not greater than 0 and not less than or equal to 32767, or is greater than the dimension of the host variable array. The number of rows that were specified is num-rows, and the dimension of the array is dimension. If this is a FETCH statement, the cursor name iscursor-name. Otherwise, the cursor name is not applicable. System action: The statement cannot be processed. THe cursor position is unchanged. Programmer response: Change the application to either declare, or allocate a host-variable-array that is large enough to contain the number of rows specified in the statement, or update the value of num-rows to a value within the valid range.

 <-  BACK TO INDEX