DB2 Version 10.1 for Linux, UNIX, and Windows
DB2 Version 10.1 for Linux, UNIX, and Windows
Returns a DB2DataReader instance containing a requested set of rows.
[Visual Basic]
Public Function ExecutePageReader( _
ByVal startRow As int, ByVal numRows As int _
) As DataReader
[C#]
public DataReader ExecutePageReader( int startRow, int numRows);
[C++]
public: DataReader^ ExecutePageReader(
int startRow, int numRows);
[JScript]
public function ExecutePageReader (
startRow : int, numRows : int
) : DataReaderReturns a DB2DataReader instance containing a requested set of rows.
[C#] The following example demonstrates the retrieval of a specific set of result set rows. In the example, a DB2DataReader containing rows three through seven is passed back to the application.
[C#]
DB2Command cmd = conn.CreateCommand();
cmd.CommandText = "SELECT * FROM SALES";
DB2DataReader dr = cmd.ExecutePageReader(3, 7);