Teradata Database Message 9823 - 17.10 - 9823 - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Messages

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1096-171K
Language
English (United States)
Message
Invalid system-time period definition.
Explanation
The data type of the start and end columns of the SYSTEM_TIME column must be of data type TIMESTAMP(6) WITH TIME ZONE. The start column must be defined with GENERATED ALWAYS AS ROW START and end column must be defined with GENERATED ALWAYS AS ROW END. The columns with GENERATED ALWAYS AS ROW START and GENERATED ALWAYS AS ROW END must participate only in SYSTEM_TIME column.
Generated By
RES modules.
For Whom
The end user.
Notes
None
Remedy
Correct the SYSTEM_TIME column definition and resubmit.