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
- The DB2 database manager enables the merging of a user-defined SQL table function that is defined as NOT DETERMINISTIC. This is the default setting.
- 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.