This is a prefetch directive that enables you to retrieve more than one read only record at a time from the DBMS with one client request.
Syntax:
PF_RO_CURSOR={numberofrows | buffersizeK | buffersizeB}
Parameters:
| numberofrows |
The number of rows to retrieve |
| buffersizeK
|
The size of the buffer you want to fill in kilobytes
|
| buffersizeB |
The size of the buffer you want to fill in bytes |
Scope:
| Used at compile time:
|
No
|
| Behavior at run time:
|
Source file
|
See
Scope - OpenESQL SQL Compiler Directive Options for more information.
Comment:
Does not work with FORWARD or IC_FH selection in RO_CURSOR.