Difference between revisions of "SYSTIMELINE"

Revision as of 14:21, 17 November 2009

Stores database timelines row versioning records

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

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

Recital, Recital Server

@@ Line 28: / Line 28: @@
 |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
 |-
 |}