Start of change

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.

End of change