9475 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.
Remedy:
Use insert select if you have to use non-deterministic UDFs/UDMs in PI columns insert into t1 select (NUDF(1,10),...);