Start of change

MATERIALIZE_NODET_SQLTUDF in macro DSN6SPRM

Specifies whether the DB2® database manager materializes the result of a user-defined SQL table function that is defined as NOT DETERMINISTIC.

Valid values are YES and NO.
NO
Start of changeThe DB2 database manager enables the merging of a user-defined SQL table function that is defined as NOT DETERMINISTIC. This is the default setting.End of change
YES
The DB2 database manager materializes the result of a user-defined SQL table function that is defined as NOT DETERMINISTIC. Use this setting to avoid errors in processing SQL statements that reference those user-defined SQL table functions.
End of change