TRANSACTION statements

Syntax

BEGIN TRANSACTION
   [statements] 
{ COMMIT [WORK] | ROLLBACK [WORK] } 
   [statements] 
[{ COMMIT [WORK] | ROLLBACK [WORK] } 
   [statements] 
   .
   .
   .               ] 
END TRANSACTION

Syntax (PIOPEN)

TRANSACTION START 
    {THEN statements [ELSE statements] | ELSE statements} 
TRANSACTION COMMIT
    {THEN statements [ELSE statements] | ELSE statements} 
TRANSACTION ABORT

Description

Use transaction statements to treat a sequence of file I/O operations as one logical operation with respect to recovery and visibility to other users. These operations can include file I/O operations or subordinate transactions.

Note: BASIC accepts PI/open syntax in addition to InfoSphere® DataStage® syntax. You cannot mix both types of syntax within a program.