Teradata Database Message 9475 - 9475 - Analytics Database - Teradata Vantage

Message

Non-deterministic UDFs/UDMs not allowed in inserted column value(s).

Explanation

Non-deterministic UDFs/UDMs can not be used to 1.) For creating a PI column value in a simple insert statement like, insert t1 (NUDF(1,10),...) 2.) For insert/update of column(PI or non-PI) value(s) through mload. As the non-deterministic UDFs/UDMs produces inconsistent results in this case.

Generated By

OptIns, OphEdIns, OphEdUpd

For Whom

End User.

Notes

None

Remedy

Use insert select if you have to use non-deterministic UDFs/UDMs in PI columns insert into t1 select (NUDF(1,10),...);