Teradata Database Message 9330 - 17.10 - 9330 - 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
ValidTime qualifier requires at least one table with ValidTime.
Explanation
A temporal ValidTime qualifier is specified in the statement and none of the referenced tables are supporting ValidTime. If the error is reported from a statement executed using a view, macro, trigger or a stored procedure , it is likely that a table was modified to remove the ValidTime column.
Generated By
RES modules.
For Whom
End User.
Notes
None
Remedy
Fix the temporal qualifier in the statement and resubmit the request. If this is occurring for a statement referenced in a view or a macro or a stored procedure then these objects may have to be recreated to correctly record the temporal qualifier.