ADELIA |
VADELIA |
SADELIA |
WADELIA |
MADELIA |
(I/B) |
(I/B) (S) |
(B) (S) |
(I/B) (S) |
(I) (S) |
Warning: With ADELIA programs generated in C, this instruction is inactive.
Section for use
All
Syntax
ROLL_BACK
Description
This instruction is used when the application operates in commitment control mode.
The opposite instruction is COMMIT.
Access to an AS/400 file
This instruction cancels the updates made to the files defined in commitment control mode (with COMMIT) since the last commitment.
To declare a file in "commitment control" mode, you have to modify the default generation options, specifying in the COMMIT column that commitment control is to be managed on the line for the relevant file.
Where a declaration is made using the DEFINE_VIEW instruction or the VIEW instruction (VADELIA), you must specify the COMMIT parameter.
Important note: The ROLL_BACK instruction can be used in a program with no files opened for commitment control.
See the relevant IBM manuals for further details on the use of the "commitment control" mode.
Access to an SQL table
This instruction cancels the updates made to SQL tables since the last commitment.
You have to disable the "Ignore commitment control" mode; see Commitment Control and the 3GL Generation tab of the Environment attributes.
Access to a Btrieve file
Adelia does not handle Btrieve file logging.
Warning:
With ADELIA programs generated in C, this instruction is inactive.
With programs other than of Adelia type, this instruction is ignored by the generator if the "Ignore commitment control" mode is active (see the 3GL Generation tab of the Environment attributes).
Example
IF CONFIRMATION_CODE = 'Y'
COMMIT
ELSE
ROLL_BACK
END