SUPPRESS_HINT_SQLCODE_DYN in macro DSN6SPRM
Specifies whether Db2 suppresses SQLCODE +394 and SQLCODE +395 when specified access paths are applied for dynamic SQL statements.
| Acceptable values: | NO, STMT, ALL |
|---|---|
| Default: | NO |
| DSNZPxxx: | DSN6SPRM SUPPRESS_HINT_SQLCODE_DYN |
| Security parameter: | No |
- NO
- Db2 issues +394 and +395 for statement-level access paths and PLAN_TABLE access paths.
- STMT
- Db2 suppresses +394 and +395 for statement-level access paths for dynamic SQL statements.
- ALL
- Db2 suppresses +394 and +395 for statement-level access paths and PLAN_TABLE access paths for dynamic SQL statements.
The SUPPRESS_HINT_SQLCODE_DYN subsystem parameter does not apply to static SQL statements or dynamic EXPLAIN statements.