DB-ROLLBACK

Perform ROLLBACK functions.
Restriction: This topic applies only when the AppMaster Builder AddPack has been installed, and applies only to Windows platforms.

Targets:

  • IMS DB
  • SQL

IMS DB

Perform ROLLBACK functions.

Syntax 
DB-ROLLBACK
General Rule:
  1. We recommend using the DB-COMMIT and DB-ROLLBACK calls instead of $IM-CHKP and $IM-ROLB.

SQL

Perform ROLLBACK functions.

Syntax 
DB-ROLLBACK
General Rules:
  1. Use DB-ROLLBACK in conjunction with a DB-BEGIN-TRAN call, which marks the beginning of the transaction. SQL statements enclosed within DB-BEGIN-TRAN and DB-ROLLBACK calls define the transaction.
  2. AMB generates logic to BEGIN-TRAN and COMMIT or ROLLBACK a set of database updates as a logical unit of work, that is, a transaction. AMB executes a BEGIN-TRAN before a DB-STORE, DB-MODIFY, or DB-ERASE, if one is not coded.

    The following variables in APSCNTL control this runtime logic. 

    % &PM-DB2-AUTO-COMMIT-SEND = "YES"
% &PM-DB2-AUTO-COMMIT-XCTL = "YES"
% &PM-DB2-AUTO-COMMIT-LINK = "YES"
% &PM-DB2-AUTO-COMMIT-TERM = "YES"

    To disable the automatic COMMIT before any of these points, set the appropriate variable to NO; to disable the automatic BEGIN-TRAN, set all the variables to NO.

Parent topic: Database Calls