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: |  NO |
| DSNZPxxx: | DSN6SPRM MATERIALIZE_NODET_SQLTUDF |
| Security parameter: | No |
- NO
- Valid values are YES and NO. The Db2 database manager enables the merging of a user-defined SQL table function that is defined as NOT DETERMINISTIC.
- 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.