Transaction Processing with IBM i Files for SQL (Magic xpa 3.x)

Due to the nature of SQL and relational database architecture, where each update can act on only one table at a time and where there are no trailers in the usual sense, two update statements must be executed simultaneously. Both update statements must either succeed and commit or fail and roll back.

In a transaction a group of updates must either COMMIT or ROLLBACK together. First a transaction is declared, and then either the COMMIT or the ROLLBACK SQL statement is issued for all the statements that have been issued since the transaction declaration.