DDF_COMPATIBILITY in macro DSN6FAC

Controls certain characteristics of a connection between a client application and a Db2 for z/OS® data server.

Deprecated subsystem parameter: Non-default settings for DDF_COMPATIBILITY are deprecated. Db2 12 supports these settings, but their use is discouraged, and support is removed in Db2 13 or later. For best results, use the default value NULL.

Values can be specified in any combination and in any order. If more than one value is specified, the values must be separated by commas, and the entire set of values must be enclosed in parentheses.

You can specify the following values for DDF_COMPATIBILITY:

null: The DDF_COMPATIBILITY parameter has no effect and Db2 12 new function behavior is used for all applications.

RESET_IFCID402

Specifies that Db2 uses a new behavior and resets IFCID 0402 counters to 0 if the associated warning or error threshold for the associated profile is changed when a START PROFILE command issued. End of change

DISABLE_IMPCAST_NJV

Specifies that the Db2 for z/OS disables implicit casting of input host variables from numeric data types to string data types, or from string data types to numeric data types, when the application is a non-Java™ client application that uses an IBM® Data Server client or driver that is at Version 10.5 or earlier.

If DISABLE_IMPCAST_NJV is not specified, Db2 enables implicit casting of input host variables from numeric data types to string data types, or from string data types to numeric data types.

IDNTFY_V12_PRIOR_VER

Specifies that a Db2 12 server at any function level identifies itself to all remote clients as a Db2 11 server in new-function mode.

Specify IDNTFY_V12_PRIOR_VER as a temporary solution if an error occurs for a connection from a remote client or driver only because the server identifies itself to the client or driver as a Db2 12 server.

IGNORE_TZ

Specifies that the time zone information is ignored during boundary error checking for TIMESTAMP WITH TIME ZONE input variables when the target data type is TIMESTAMP and the client driver is IBM Data Server Driver for JDBC and SQLJ.

IGNORE_TZ is deprecated. IGNORE_TZ is effective only if application compatibility is set to V10R1.

Start of change IGNORE_TZ is not needed and has no effect if the client JDBC driver is at version 3.63 or 4.13, or later. End of change

SP_PARMS_NJV

Specifies that when a non-Java client application calls a Db2 for z/OS stored procedure, Db2 returns output argument values with data types that match the data types of the corresponding CALL statement arguments.

Exception: Start of change

For stored procedure parameters with data types that were introduced in DB2® 10 (XML, TIMESTAMP WITH TIMEZONE, or TIMESTAMP with precision greater than 6), the data types of output argument values do not match the data types of the corresponding CALL statement arguments. Instead, the data types of the output argument values match the data types of the corresponding parameters in the stored procedure definition. End of change

If SP_PARMS_NJV is not specified, Db2 returns output parameter values with data types that match the data types of the parameters in the stored procedure definition.

SP_PARMS_NJV is deprecated. Db2 ignores this value if application compatibility is set to V11R1 or later.