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. Valid values of SUPPRESS_HINT_SQLCODE_DYN are NO, STMT, and ALL.
A value of NO specifies that DB2 issues SQLCODEs +394 and +395 for statement-level access paths and PLAN_TABLE access paths. NO is the default value.
A value of STMT value specifies that DB2 suppresses SQLCODEs +394 and +395 for statement-level access paths for dynamic SQL statements.
An value of ALL specifies that DB2 suppresses SQLCODEs +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.