solidDB Help : solidDB reference : SQL: Statements : SET : SET [DELETE] CAPTURE
  
SET [DELETE] CAPTURE
SET [DELETE] CAPTURE {NONE | CHANGES}
Access requirements
Database user
Usage
Use the SET [DELETE] CAPTURE statement in a replicated environment to control the changes that are replicated from the source database to a target database.
The SET [DELETE] CAPTURE statement takes effect immediately, starting from the next SQL statement, until it is reverted by a similar statement or by using SET TRANSACTION [DELETE] CAPTURE, see SET TRANSACTION [DELETE] CAPTURE.
Parameters, clauses, keywords, and variables
▪ NONE:
– With SET DELETE CAPTURE: Data aging is enabled. 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 CAPTURE: No changes (deletes, inserts, or updates) to data in the source database are replicated to the target database.
▪ CHANGES: (default) All changes (deletes, inserts, and updates) to data in the source database are replicated to the target database.
Examples
SET DELETE CAPTURE NONE
SET CAPTURE NONE
Go up to
SET