Working with Transactions (Magic xpa 3.x)
A transaction is a sequence of one or more SQL statements that are closely related but perform interdependent actions that form a logical unit of work. Each statement in the transaction performs some part of a task, but all of the statements are required to complete the task. The DBMS executes the sequence as one operation because the statements are grouped as a single unit. All the statements must be completed for the database to remain consistent. When applications update multiple tables in a database, transactions ensure database integrity.
If the transaction does not complete successfully, a ROLLBACK statement returns the data to the state it was in prior to the beginning of the transaction. If the transaction completes successfully, a COMMIT statement permanently stores the data in the database.
Magic xpa Transactions and AS/400 Files
Transaction Processing with IBM i Files for SQL
