Transactions

A transaction is a series of one or more operations on database-related objects, data, or both.

Transactions provide the following benefits:

Ensure integrity among multiple operations by allowing all or none of the operations to take effect. You accomplish this by starting a transaction, performing operations, and then executing either a commit or a rollback (also called an abort).
Provide a means of canceling completed work for a series of operations that fail before finishing.
Provide a consistent view of data to users, in the midst of changes by other users. The combination of create and delete transaction IDs associated with each data row plus IBM® Netezza® internal controls ensure that after a transaction begins, new transactions or ones that have yet to be committed do not affect the view of the data.