Difference between revisions of "CLEAR TIMELINE"

From Recital Documentation Wiki
Jump to: navigation, search
Line 30: Line 30:
 
[[Category:Commands]]
 
[[Category:Commands]]
 
[[Category:Database Timelines]]
 
[[Category:Database Timelines]]
[[Category:Database Timelines Commands]]
 

Revision as of 08:51, 6 July 2011

Purpose

Clears database timeline transaction information


Syntax

CLEAR TIMELINE


See Also

DISPLAY TIMELINE, DTOS(), LIST TIMELINE, ROLLBACK TIMELINE, SET TIMELINE, SET TIMESTAMP, SYSTIMELINE, TIME()


Description

CLEAR TIMELINE deletes database timeline transaction information. Database timelines provide row versioning for Recital database applications. Whenever a change is made to a table that is timeline enabled, delta changes are automatically recorded for each transaction.

CLEAR TIMELINE permanently deletes all records in the database timeline storage table, SYSTIMELINE.

To enable database timelines simply issue the SET TIMELINE ON command in your Recital configuration file. SET TIMELINE is OFF by default.


Example

clear timeline


Products

Recital, Recital Server