DEF_CURSOR

This cursor directive specifies the default cursor type for ambiguous COBOL cursors, either read only or updateable. Use this directive when the DECLARE CURSOR statement has neither the FOR READONLY nor the FOR UPDATE OF clause.

Syntax:

DEF_CURSOR={RO | UPD}

Comments:


  • RO is read only
  • UPD is updateable
  • On the mainframe, the default is usually RO
  • The ANSI SQL default is UPD; however, if the original developer assumed RO, use of UPD could adversely affect performance
Parent topic: Primitive Directives