Rocket® Enterprise Developer (formerly a product of Micro Focus or formerly a product of Open Text) documentation, created before Rocket Software acquired certain products from OpenText, may include outdated references to "Micro Focus" or "OpenText", both of which are trademarks of OpenText or its affiliates. Rocket Software is not affiliated with Micro Focus or OpenText and has since rebranded these products as Rocket® products. You may also encounter outdated links in this documentation. If you do, please contact Rocket Support (support@rocketsoftware.com) for assistance.
PF_RO_CURSOR
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}
Properties:
| Default for SQL Server connections: | 8 |
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.
Comments: