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.