Teradata Database Message 5784 - 5784 - 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
Illegal usage of Identity Column %VSTR.
Explanation
User attempted to define an invalid identity column or use an identity column incorrectly. The error is returned if: 1) an identity column is defined as a) part of a composite index b) a join index or hash index c) a primary partition index d) a value-ordered index. 2) the input parameter of an INSERT into identity column is a using field (e.g., :F1) which is part of an expression, e.g. :F1+:F2 or :F1+2. 3) an identity column is defined in a temporary or volatile table. It may only be defined in a permanent table. 4) a USING statement contains multiple INSERT statements that insert into different identity column tables. 5) the input parameter of an INSERT into identity column of type BY DEFAULT is a using field (e.g., :F1) that is being reused in another parameter in the insert statement, e.g. USING(F1 INT, F2 INT) INS tab(:F1,:F1);
Generated By
SYN, RES, OPT modules.
For Whom
End User.
Notes
None
Remedy
Modify the statement accordingly and re-submit the request.