Transaction Processing
When you attempt to insert data into a table, Pervasive PSQL returns an error if the data is invalid. Any data inserted before the error occurred is rolled back. This enables your database to remain in a consistent state.
You can use transaction processing in a Pervasive PSQL database to group a set of logically related statements together. Within a transaction, you can use savepoints to effectively nest transactions; if a statement in a nesting level fails, then the set of statements in that nesting level is rolled back to the savepoint. Refer to the following topics in
SQL Engine Reference
for information about transaction processing and savepoints:
•
START TRANSACTION
•
COMMIT
•
ROLLBACK
•
SAVEPOINT
•
RELEASE SAVEPOINT