Products Downloads


French version


 

 

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

 

↑ Top of page


  • Aucune étiquette