17.05 - Example: Nonsequenced Valid-Time Insert into a Valid-Time Table - Teradata Database

Teradata Vantage™ - Temporal Table Support

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
17.05
created_date
June 2020
category
Programming Reference
featnum
B035-1182-170K

A nonsequenced valid-time insert is similar to a conventional insert where the valid-time column is treated as any other column in the table.

Consider the same valid-time table as in the previous examples. The following statements perform nonsequenced valid-time inserts into the Policy table.

   NONSEQUENCED VALIDTIME INSERT INTO Policy
      VALUES (540232, 455909234, 'AU', 'STD-CH-344-YYY-00',
         PERIOD (DATE '2009-01-01', DATE '2009-12-31'));

   NONSEQUENCED VALIDTIME INSERT INTO Policy
      (Policy_ID, Customer_ID, Policy_Type, Policy_Details, Validity)
      VALUES (540944, 123344567, 'AU', 'STD-PL-332-YXY-01',
         PERIOD (DATE '2007-02-03', DATE '2008-02-02'));