SYSTIMELINE
From Recital Documentation Wiki
Revision as of 16:12, 17 November 2009 by Yvonnemilne (Talk | contribs)
Contents
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 |
|---|---|---|---|
| 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
