15.00 - 9331 TransactionTime qualifier requires at least one table with TransactionTime. - Teradata Database

Teradata Database Messages

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1096-015K
Language
English (United States)

9331 TransactionTime qualifier requires at least one table with TransactionTime.

Explanation:

A temporal TransactionTime qualifier is specified in the statement and none of the referenced tables are supporting TransactionTime. 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 TransactionTime column.

Generated By:

RES modules.

For Whom:

End User.

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.