ROLLBACK 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)
ROLLBACK 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 ROLLBACK WORK statement terminates a unit of recovery and backs out the CA Datacom/DB database changes made by that unit of recovery.

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.

Also, see the CA Datacom/DB Database and System Administration Guide for information on DIAGOPTION line 0,128,ON. This line can change the resulting cursor state (open or closed) following a ROLLBACK WORK statement when SQLMODE=DATACOM is specified. This option is not recommended for general use.

Following is the syntax diagram for the ROLLBACK WORK statement:

Note: ROLLBACK (without the keyword WORK) is a CA Datacom/DB extension.

►►─┬─ ROLLBACK WORK ─┬────────────────────────────────────────────────────────►◄
   └─ ROLLBACK ──────┘