SET TRANSACTION [DELETE] CAPTURE {NONE | CHANGES | DEFAULT}
Access requirements
Database user
Usage
Use the SET TRANSACTION [DELETE] CAPTURE statement in a replicated environment to control the changes that are replicated to the target database in the next transaction.
The SET TRANSACTION [DELETE] CAPTURE statement takes effect at the beginning of a transaction, and it affects the transaction until the transaction is committed or rolled back. If the statement is issued in the middle of a transaction, an error is returned.
Parameters, clauses, keywords, and variables
▪ NONE:
– With SET TRANSACTION DELETE CAPTURE: Data aging is enabled for the current transaction. Data aging removes table rows from the source database but preserves the rows in the target database by preventing the replication of deletions. Rows that are inserted or updated in the source database are still replicated to the target database.
– With SET TRANSACTION CAPTURE: No changes (deletes, inserts, or updates) to data in the source database are replicated to the target database.
▪ CHANGES: All changes (deletes, inserts, and updates) to data in the source database are replicated to the target database.
▪ DEFAULT: (default) The data capture mode returns to the mode that was set with a previous SET CAPTURE statement or, if no SET CAPTURE statement was executed, the server default. For more information, see SET [DELETE] CAPTURE.