Vantage provides statement independence for multiple-statement INSERT requests and iterated INSERT requests. Statement independence enables multiple-statement or iterated INSERT requests to roll back only the statements that fail within a transaction or multiple-statement request and not all of the individual statements within the transaction.
- INSERT; INSERT; INSERT;
- BT; INSERT; INSERT; ET;
- BT; INSERT; INSERT;
- INSERT; INSERT; ET;
- INSERT; COMMIT;
- INSERT; INSERT; COMMIT;
Most statement data errors resulting from multiple-statement INSERT requests only roll back failed requests within the transaction or multiple-statement request, but do not stop all of the statements within the transaction or request unless every INSERT request within the multiple-statement request stops because of data-related errors. The database does not roll back the transaction, only its INSERT requests.
- Column-level CHECK constraint violations
- Data translation errors
- Duplicate row errors for SET tables
- Primary index uniqueness violations
- Referential integrity violations
- Secondary index uniqueness violations
- Triggers
- Join indexes
- INSERT ... SELECT requests
- SQL stored procedures