Previous Topic Next topic Print topic


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}

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.

Previous Topic Next topic Print topic