Teradata Database Message 3719 - 17.10 - 3719 - 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
Join update of non-hashed table '%VSTR' is not allowed.
Explanation
The submitted request requires a complex update (for example, a join update) of a non-hashed table. Such updates are not allowed.
Generated By
OPT modules.
For Whom
End User.
Notes
This event code applies to some non-hashed system tables that are owned by user DBC. It does not apply to user tables or any other hashed tables. To determine whether your Teradata SQL request involves a complex update, use the EXPLAIN modifier.
Remedy
Change the request to use a simpler operation such as a single-table update, or submit the request for user tables only. If this event code occurs after the above actions are taken, contact your support representative.