Specifies the number of rows of data the driver attempts to fetch for each ODBC call.
Valid Values
0 | x
where:
x
is a positive integer from 1 to 2000 that defines a number of rows.
Behavior
If set to 0, the driver attempts to fetch up to a maximum of 2000 rows. This value typically provides the maximum throughput.
If set to x, the driver attempts to fetch up to a maximum of the specified number of rows. Setting the value lower than 2000 can reduce the response time for returning the initial data. Consider using a smaller WSFetch Size for interactive applications only.
