The number of rows returned at one time by a query is controlled by the SQL client application, not by the SQL engine or JDBC or ODBC drivers. There are no
An example of a SQL client application that can do this is the Progress SQL Explorer tool, that controls the number of records returned at one time with a Record Fetch Limit setting. The default setting is 101 rows.
In the character SQL Explorer tool, (available in all Progress / OpenEdge versions supporting SQL-92), enter the following from the command line, replacing "<n>" with the desired number of records to be returned:
In the GUI SQL Explorer tool, (available in OpenEdge 10.0B or earlier), the default Record Fetch Limit may be changed using the menu option View -> Options -> Report Formatting.
To turn off the fetch limit use the following SQL statement prior to running other SQL statements which retrieve records:
Please note that the Fetch Array Size setting of a driver represents the number of rows that the driver retrieves when fetching from the server. This setting does not limit the number of results returned, nor is it the number of rows given to the user.