Difference between revisions of "CLEAR TIMELINE"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| Line 1: | Line 1: | ||
| − | + | ==Purpose== | |
| + | Clears database timeline transaction information | ||
| + | |||
| + | |||
| + | ==Syntax== | ||
| + | CLEAR TIMELINE | ||
| + | |||
==See Also== | ==See Also== | ||
| − | [[LIST TIMELINE]], [[ROLLBACK TIMELINE]], [[SET TIMELINE]], [[SET TIMESTAMP]], [[SYSTIMELINE]] | + | [[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== | ||
| + | <code lang="recital"> | ||
| + | clear timeline | ||
| + | </code> | ||
Revision as of 16:58, 1 December 2009
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
