SQL Guide : solidDB® SQL statements : SET : SET DELETE CAPTURE
  
SET DELETE CAPTURE
SET DELETE CAPTURE {NONE | CHANGES}
Usage
The SET DELETE CAPTURE statement sets the data aging mode in solidDB® Universal Cache. Data aging removes table rows from the front-end but preserves them in the back-end.
SET DELETE CAPTURE NONE: data aging is enabled
SET DELETE CAPTURE CHANGES: data aging is disabled
The SET DELETE CAPTURE statement takes effect immediately, starting from the next SQL statement, until it is reverted by a similar statement or SET TRANSACTION DELETE CAPTURE.
See also
SET TRANSACTION DELETE CAPTURE
See also
SET