Difference between revisions of "SYSTIMELINE"

From Recital Documentation Wiki
Jump to: navigation, search
Line 28: Line 28:
 
|COMMAND||C||20||Command that changed the data
 
|COMMAND||C||20||Command that changed the data
 
|-
 
|-
|OLDDATA||M||8||Data affected by change
+
|OLDDATA||M||8||Affected data prior to change
 
|-
 
|-
|NEWDATA||M||8||Affected data prior to change
+
|NEWDATA||M||8||Data after change
 
|-
 
|-
 
|}
 
|}

Revision as of 14:21, 17 November 2009

Purpose

Stores database timelines row versioning records


See Also

CLEAR TIMELINE, LIST TIMELINE, SET TIMELINE, SET TIMESTAMP, SYSTEM TABLES


Description

System Tables are system defined read-only tables. You can query these tables using the SELECT statement.


Column Data Type Width Description
TABLE C 30 Master table name
RUID C 16 Unique row id
RID I 11 Table row id
USER C 20 User login that changed the data
LOCATION C 30 IP address of the master data server
TIMESTAMP C 16 Timestamp from the master record
COMMAND C 20 Command that changed the data
OLDDATA M 8 Affected data prior to change
NEWDATA M 8 Data after change


Example

SELECT * FROM systimeline WHERE between(timestamp, '20091001', '20091007')


Products

Recital, Recital Server