Transaction Management

Depending on how the transaction options are set in ODBC.INI for data sources, any changes to the data source tables may not be committed$($changes become permanent$)$ until the user expicitly issues a commit statement. The predicate odbc_transaction/1 is provided in this sense.

odbc_transaction(commit)

Commits all transactions up to this point.

odbc_transaction(rollback)

Rolls back all transactions$($discard the changes made$)$ since the last commit.