This error was received after executing the following DDL statement for bitemporal table:
 

This may seem like a fundamental question, but I have been playing around with the temporal keywords and have yet to come up with the desired results.

Is there a way to get an answerset with only closed records?

Dear Teradata fan community,

we know, that since release 13.10 there exists temporal capability within the database. My understanding specially about the transaction time is, that this data will be handled automatically within the DBMS as described as follow:

"A transaction-time column records and maintains the time period for
which Teradata Database was aware of the information in the row.
Teradata Database automatically enters and maintains the
transaction-time column data, and consequently automatically tracks
the history of such information."