Transaction statements are used to start and terminate explicit transactions.

A transaction asserts data integrity by demanding that all statements executed in the context of the transaction must complete successfully before the transaction can be committed, otherwise the transaction is aborted and no changes are updated in the database.

Note: If an explicit transaction is not active, then each SQL statement starts an implicit transaction which is automatically committed when the SQL statement terminates.

Tip: Use transaction blocks to speed up the execution of bulk data-change statements.

Home | Site Contents | Documentation | NexusDB Manual V4 | SQL Reference | SQL Statements