- Nonsequenced
- Sequenced
PTI tables include the system generated TD_TIMECODE column. The TD_TIMECODE value must be the first value in the value list for inserts into nonsequenced and sequenced PTI tables. When inserting into a PTI table, the TD_TIMECODE value cannot precede the timezero value specified in the PTI definition, for example DATE '2016-10-15'.
Sequenced PTI tables also include the TD_SEQNO column. This must be the second value in the value list for inserts into a sequenced PTI table.
In sequenced tables, rows are ordered according the TD_TIMECODE value and then the TD_SEQNO value. Row ordering is automatic, so inserts can occur in any order.
The table below summarizes inserts into the system generated PTI table columns.
Column | Description |
---|---|
TD_TIMECODE | This is a system generated column for sequenced PTI tables. This is a non-nullable column. You must provide a value. This must be the first value in the value list for inserts. You cannot provide CURRENT_TIMESTAMP, CURRENT_TIME, or CURRENT_DATE as a value. |
TD_SEQNO | This is a system generated column for sequenced PTI tables. This is a non-nullable column. You must provide a value. This must be the second value in the value list for inserts into a sequenced PTI table. |
INSERT Restrictions
Isolated loading is not supported for inserts into PTI tables.
The DEFAULT VALUES option is not supported for inserts into PTI tables.