Transaction control statements

Previous Next

Executing one or more DML statements causes a transaction to be set up. The data changes represented by the DML statement(s) do not become definitive and visible to all users until the transaction is committed.

Until you commit, you have the option to revert or roll back to the state of the database that occurred prior to your first DML statement.

The USoft Rules Engine supports the COMMIT and ROLLBACK transaction control statements.

 

 

collapseCOMMIT statement
collapseROLLBACK statement

 

 

See also

Queries and subqueries

Join constructs

DML statements

Table aliases

Set operators

Method invocation statements