COMMIT_COUNT configuration variable

The value of COMMIT_COUNT indicates the conditions under which you want Database Connectors 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 Database Connectors when COMMIT_COUNT is set to -1; the alternative when this is set:

  • Call your Oracle query tool with COMMIT WORK or ROLLBACK WORK

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 Supported Features for Oracle Information.