Difference between revisions of "SET SYSTIMELINE"

From Lianjapedia
Jump to: navigation, search
(See Also)
Line 6: Line 6:
  
 
==See Also==
 
==See Also==
[[ALTER DATABASE]], [[CLEAR TIMELINE]], [[LIST TIMELINE]], [[MetaData Editor]], [[ROLLBACK TIMELINE]], [[SET TIMELINE]], [[SET TIMESTAMP]], [[SYSTIMELINE|Systimeline System Table]], [[TIMELINE()]], [[Timeline Section Attributes]], [[Understanding database timelines in Lianja|Understanding Database Timelines]]
+
[[ALTER DATABASE]], [[CLEAR TIMELINE]], [[:Category:Database Timelines|Database Timelines Commands and Functions]], [[Database Timelines (Video)]], [[LIST TIMELINE]], [[MetaData Editor]], [[ROLLBACK TIMELINE]], [[SET TIMELINE]], [[SET TIMESTAMP]], [[SYSTIMELINE|Systimeline System Table]], [[TIMELINE()]], [[Timeline Section Attributes]], [[Understanding database timelines in Lianja|Understanding Database Timelines]]
  
 
==Description==
 
==Description==

Revision as of 07:20, 26 March 2020

Purpose

Enable global database timeline override

Syntax

SET SYSTIMELINE ON | OFF

See Also

ALTER DATABASE, CLEAR TIMELINE, Database Timelines Commands and Functions, Database Timelines (Video), LIST TIMELINE, MetaData Editor, ROLLBACK TIMELINE, SET TIMELINE, SET TIMESTAMP, Systimeline System Table, TIMELINE(), Timeline Section Attributes, Understanding Database Timelines

Description

Database timelines provide row versioning for Lianja database tables. Whenever a change is made to a table that is timeline enabled, delta changes are automatically recorded for each transaction. Changes made to any tables that are timeline enabled can be undone much like you would undo changes to program code that you edit in a text editor. The global setting SET SYSTIMELINE must be ON to use the SET TIMELINE command or Timeline Attributes to enable timelines for an individual table or application. SET SYSTIMELINE is ON by default.

Timelines are used extensively with Lianja Mobile to perform merged synchronizations between mobile devices and the Lianja Cloud Server.

Example

set systimeline on
set timeline on