Micro Focus Visual COBOL 2.3 for Visual Studio 2015 > Programming > Data Access > Database Connectors > Database Connectors Reference > Configuration Variables > COMMIT_COUNT configuration variable

COMMIT_COUNT configuration variable

Restriction: This topic applies only when a Database Connectors license has been installed via the Micro Focus License Management System.

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:

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