A fetch array
A fetch array enables you to increase the number of rows that a single FETCH statement returns from the fetch buffer to an sqlda structure in your program. A fetch array is especially useful when you fetch simple-large-object (TEXT or BYTE) data.
A fetch of simple-large-object data without a fetch array requires
the following two exchanges with the database server:
- When fetches a TEXT or BYTE column, the database server returns the descriptor for the column.
- then requests the database server to obtain the column data.
When you use a fetch array, sends a series of simple-large-object descriptors to the database server and the database server returns the corresponding column data all at one time.