PF_UPD_CURSOR

This is a prefetch directive that enables you to retrieve more than one updateable record at a time from the DBMS with one client request.

Syntax:

PF_UPD_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 selection in UPD_CURSOR.
Parent topic: Primitive Directives