COMMIT WORK

This SQL statement can be executed in the following ways:	Through the CA Datacom Datadictionary Interactive SQL Service Facility (interactive)	In an application program prepared using a CA Datacom/DB SQL Preprocessor (embedded)	By using CA Dataquery (SQL & Batch Modes)
COMMIT WORK	YES	YES

Note: YES indicates a valid execution method for this statement. For information about the access rights required to execute this statement, see the CA Datacom/DB Database and System Administration Guide.

The COMMIT WORK statement terminates a unit of recovery and commits the database changes that were made by that unit of recovery. The commit closes all open cursors.

Note: If a cursor is defined WITH HOLD, it stays open when a COMMIT WORK is executed. Any record-at-a-time command that commits the logical unit of work (for example LOGCP, LOGCR) works the same way. See the description of the WITH HOLD clause in DECLARE CURSOR.

A commit point is the moment in the sequence of operations at which the commit is actually done.

Following is the syntax diagram for the COMMIT WORK statement:

Note: COMMIT is a CA Datacom/DB extension.

►►─┬─ COMMIT WORK ─┬──────────────────────────────────────────────────────────►◄
   └─ COMMIT ──────┘