Teradata Database Message 9826 - 17.10 - 9826 - 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
The column name specified in the <without overlap specification> must be a ValidTime column defined using derived period.
Explanation
If the unique or primary key constraint is defined with <without overlaps specification>, then the ValidTime column name specified in the <without overlaps specification> must be of a column defined with derived period definition.
Generated By
RES modules.
For Whom
The end user.
Notes
None
Remedy
Define the ValidTime column using derived period definition and resubmit.