COMMIT_COUNT configuration variable

The value of COMMIT_COUNT indicates the conditions under which you want to issue an automatic COMMIT_WORK operation.

COMMIT_COUNT <value>

Valid values are:

"0" A commit is issued when no locks are held, either because all files that had locked records have been closed, or because a COBOL COMMIT verb has been issued. This is the default value
"n" A commit is issued after n operations. WRITE, REWRITE, and DELETE count towards n; READ, START, and READ NEXT do not
"-1"

No commit is issued by the Connector. When COMMIT_COUNT is set to "-1", there are two alternate ways to perform a commit or rollback:

  • One way is to call your Oracle query tool with COMMIT WORK or ROLLBACK WORK
  • The second way is to use the COBOL verbs COMMIT and ROLLBACK, available in your COBOL development system

COMMIT_COUNT is set to "-1" internally when you use the transaction management facilities available in the Compiler.

A COMMIT WORK, however, is issued on exit from the run-time system (for example, on execution of a STOP RUN)

For information about supported features, see the section Supported Features in the appendix Database Connector for Oracle Information.