15.00 - 9328 History rows in a table with TransactionTime cannot be modified. - Teradata Database

Teradata Database Messages

Product
Teradata Database
Release Number
15.00
Language
English (United States)
Last Update
2018-09-24

9328 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.

Remedy:

Prefix the ALTER TABLE with NONTEMPORAL and retry.