SYSTIMELINE
From Recital Documentation Wiki
Revision as of 12:09, 17 November 2009 by Yvonnemilne (Talk | contribs)
Contents
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 | Table name |
| RUID | C | 16 | |
| RID | I | 11 | |
| USER | C | 20 | |
| LOCATION | C | 30 | |
| TIMESTAMP | C | 16 | |
| COMMAND | C | 20 | |
| OLDDATA | M | 8 | |
| NEWDATA | M | 8 |
Example
SELECT * FROM systimeline WHERE between(timestamp, '20091001', '20091007')
Products
Recital, Recital Server
