Kbase P7136: What does the "Fetch Array Size" feature mean in the SQL-92 ODBC Driver ?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Verified
GOAL:
What does the "Fetch Array Size" feature mean in the SQL-92 ODBC Driver ?
FACT(s) (Environment):
Progress 9.x
FIX:
The Fetch Array Size parameter allows to set the maximum number of rows that are permitted in a FETCH procedure. This value determines the packet size on the network.
Example, if the Array Fetch is set to 20, and you plan to retrieve 100 rows, then five fetches will be executed to retrieve the data.