Purpose

Specifies the number of rows of data the driver attempts to fetch for each JDBC 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.

Default

0 (up to a maximum of 2000 rows)

Data Type

Int