DB2®ResultSet.BlockForNRows Property
Controls the number of rows to be returned to client in a single fetch request. The value set here would override any value set in the DB2Command object that created this result set.
- Namespace:
IBM.Data.DB2- Assembly:
IBM.Data.DB2(inIBM.Data.DB2.dll)
Syntax
[Visual Basic]
Public Property BlockForNRows As Integer
[C#]
public int BlockForNRows {get; set;}
[C++]
public: __property int get_BlockForNRows();
public: __property void set_BlockForNRows(int);
[JScript]
public function get BlockForNRows() : int;
public function set BlockForNRows(int);
Property value
A positive integer n, where rows of data will be returned in a single fetch request to the client.
Exceptions
| Exception type | Condition |
|---|---|
| InvalidArgumentException | The property value is a negative number. |
| InvalidOperationException | The property value is set for non Forward-only cursors. |
Remarks
The BlockForNRows setting will be silently ignored when reading data from a page reader.