SYSTIMELINE

Purpose

Stores database timelines row versioning records

See Also

CLEAR TIMELINE, LIST TIMELINE, ROLLBACK 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
DATABASE	C	30	Master database name
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 where data was changed from
TIMESTAMP	C	16	Timestamp of change
COMMAND	C	20	Command that changed the data
OLDDATA	M	8	Data before change
NEWDATA	M	8	Data after change

Example

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

Products

Recital, Recital Server