Teradata Database Message 5586 - 5586 - Analytics Database - 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),...);