SYSTIMELINE

From Recital Documentation Wiki
Revision as of 12:32, 17 November 2009 by Yvonnemilne (Talk | contribs)

Jump to: navigation, search

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 Data affected by change
NEWDATA M 8 Affected data prior to change


Example

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


Products

Recital, Recital Server