The SET TRANSACTION DELETE CAPTURE statement sets the data aging mode for the next transaction. Data aging removes table rows from the front-end but preserves them in the back-end.
NONE
data aging is enabled
CHANGES
data aging is disabled
DEFAULT
the data capture mode returns to the mode set with a previous SET DELETE CAPTURE statement, or the server's default.
The SET TRANSACTION DELETE CAPTURE statement has effect in the beginning of a transaction, and it affects the transaction until commit or abort. If the statement is issued in the middle of a transaction, an error is returned.