Perform ROLLBACK functions.
Restriction: This topic applies only when the AppMaster Builder AddPack has been installed, and applies only to Windows platforms.
IMS DB
Perform ROLLBACK functions.
- Syntax
-
DB-ROLLBACK
- General Rule:
-
- 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:
-
- 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.
- 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.
