Teradata Database Message 9328 - 17.10 - 9328 - 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
History rows in a table with TransactionTime cannot be modified.
Explanation
The specified ALTER TABLE statement is modifying the values of one of the columns of the TransactionTime table without the use of NONTEMPORAL statement prefix. The closed rows in a table with TransactionTime support cannot be modified unless the user has a NONTEMPORAL privilege.
Generated By
RES modules.
For Whom
End User.
Notes
None
Remedy
Prefix the ALTER TABLE with NONTEMPORAL and retry.