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.

Acceptable values: NO, YES
Default: Start of changeNOEnd of change
DSNZPxxx: DSN6SPRM MATERIALIZE_NODET_SQLTUDF
Security parameter: No
NO
The Db2 database manager enables the merging of a user-defined SQL table function that is defined as NOT DETERMINISTIC. NO is the default value.
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.