RO_CURSOR

This directive determines what type of database cursor your COBOL read only cursors use.

Syntax:

RO_CURSOR={SCROLL | FORWARD | DYNAMIC | KEYSET | STATIC | FF | IC_FH}

Comments:


  • SCROLL, FORWARD, DYNAMIC, and KEYSET are standard ODBC types.
  • FF (fast forward) and IC_FH (independent connection fire hose) are cursors specific to MS SQL Server.
  • Under MS SQL Server, prefetching does not work with FORWARD and IC_FH.
  • As its name indicates, an IC_FH cursor has its own independent connection to MS SQL Server. Because of this, these cursors are sensitive to the isolation level and locking protocol of previous data access in the application program.
Parent topic: Primitive Directives