DB-COMMIT

Perform database COMMIT 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

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

SQL

Syntax:
DB-COMMIT [HOLD]
Parameters:
HOLD

Do not release resources; do not close open cursors; preserve prepared SQL statements; release locks on specific rows acquired during the transaction.