Teradata Database Message 5784 - 17.10 - 5784 - 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
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.