Teradata Database Message 9248 - 17.10 - 9248 - 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
Object is not associated with CURRENT_DATE or CURRENT_TIMESTAMP.
Explanation
For an ALTER TABLE statement with the TO CURRENT clause, the table or join index must use CURRENT_DATE or CURRENT_TIMESTAMP in the PPI definition.
Generated By
OPD modules
For Whom
End user
Notes
None
Remedy
Check the PPI definition and see if ALTER TABLE MODIFY PRIMARY INDEX or ALTER TABLE REVALIDATE PRIMARY INDEX must be used.