Ends a transaction and makes any changes that you made during that transaction permanent. SQL does not allow a COMMIT statement in an ATOMIC compound statement. The AND CHAIN clause can also be used to start a new transaction. See the COMMIT help topic for a complete description.