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}

Comments:


  • numberofrows is the number of rows to retrieve.
  • buffersizeK is the size of the buffer you want to fill in kilobytes.
  • buffersizeB is the size of the buffer you want to fill in bytes.
  • Does not work with FORWARD or IC_FH selection in RO_CURSOR.
Parent topic: Primitive Directives