Teradata Database Message 5586 - 5586 - 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
- Random not allowed in inserted column value(s).
- Explanation
- Use of random function disallowed for either of the cases: 1.) For creating a PI column value in a simple insert statement like, insert t1 (random(1,10),...). 2.) For insert/update of column(PI or non-PI) value(s) through mload. As the random function may produce inconsistent results.
- Generated By
- OptIns,OptEdIns,OptEdUpd
- For Whom
- End User.
- Notes
- None
- Remedy
- Use insert select if you have to use Random in PI columns insert into t1 select (random(1,10),...);