This document covers the following topics:
Belongs to Function Group: Database Access and Update
See also COMMIT - SQL in the Natural for DB2 part of the Database Management System Interfaces documentation:
COMMIT statement corresponds to the
statement. It indicates the end of a logical transaction and releases all data
locked during the transaction. All data modifications are committed and made
As all cursors are closed when a logical unit of work ends, a
COMMIT statement must not be placed within a database
modification loop; instead, it has to be placed outside such a loop or after
the outermost loop of nested loops.
If an external program written in another standard programming
language is called from a Natural program, this external program should not
contain its own
COMMIT statement if the Natural program issues
database calls, too. The calling Natural program should issue the
COMMIT statement on behalf of the external program.
... DELETE FROM SQL-PERSONNEL WHERE NAME = 'SMITH' COMMIT ...