Teradata Database Message 5977 - 5977 - Analytics Database - Teradata Vantage
Teradata® VantageCloud Lake - Analytics Database Messages
- Edition
- Lake
- Product
- Analytics Database
- Teradata Vantage
- Published
- October 2022
- Language
- English (United States)
- Last Update
- 2024-02-26
- dita:mapPath
- tzr1629746512312.ditamap
- dita:ditavalPath
- ft:empty
- dita:id
- vza1585613049811
- lifecycle
- latest
- Product Category
- Teradata® Vantage™
- Message
- Invalid MERGE-INTO statement: %VSTR
- Explanation
- The user specified a MERGE-INTO statement that violated one of the following Teradata exceptions to Full ANSI MERGE standards: a) The <search condition> following the ON keyword must specify an equality constraint on the primary index of the target table. The specified primary index value must match the primary index value implied by the column values specified in the INSERT clause. If the PI value is the result of an expression, the expression cannot reference any column in the target table. Additionally, the <search condition> may not contain subqueries or references to columns that do not belong to either the source or target table. If the target table is a PPI table, the values of the partitioning columns must also be specified in the <search condition>, and the INSERT clause must specify the same partitioning column values as the <search condition>. b) UPDATEs of the primary index column(s) are not supported. For PPI tables, this restriction is further extended to not supporting UPDATEs on partitioning column(s) as well. c) PI of the Target table cannot be an identity column d) MERGE-INTO is not allowed on an Unhashed table e) MERGE-INTO is not allowed on a table with a primary index and column partitioning. f) MERGE-INTO is not allowed on a table with a primary AMP index
- Generated By
- Parser.
- For Whom
- End User.
- Notes
- None
- Remedy
- Correct the statement and re-submit the request.