Maintain Data Integrity
You can maintain database integrity by using one or more of the following features:
-
A DeleteAction element maintains database consistency when a record is deleted. For more information about adding a DeleteAction element, see Create Delete Actions.
Note If you add a DeleteAction to a table and you use the delete_from statement, database performance will be slow. For more information, see delete_from.
-
The forUpdate keyword in a select statement and the selectForUpdate table method ensure that records must be selected before they are updated or deleted. For more information, see Select Statement Syntax.
-
The ttsbegin, ttscommit, and ttsabort keywords ensure that all changes that are associated with a transaction are completed successfully. If the changes are not successfully completed, the transaction is aborted and the database is rolled back to the initial state.