Purpose

Specifies the number of rows of data the driver attempts to fetch from the native data source on each request submitted to the server.

Valid Values

0 | x

where:

x
is a positive integer that defines the number of rows.

Behavior

If set to 0, the driver requests that the server return all rows for each request submitted to the server. Block fetching is not used.

If set to x, the driver attempts to fetch up to a maximum of the specified number of rows on each request submitted to the server.

Notes

NativeFetchSize is related to, but different than, FetchSize. NativeFetchSize specifies the number of rows of raw data that the driver fetches from the native data source, while FetchSize specifies how many of these rows the driver processes before returning control to the application. Processing the data includes converting native data types to SQL data types used by the application. If FetchSize is greater than NativeFetchSize, the driver may make multiple round trips to the data source to get the requested number of rows before returning control to the application.

Data Source Method

setNativeFetchSize

Default

10000 (rows)

Data Type

Int

See also