DDF_COMPATIBILITY in macro DSN6FAC

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

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. For example, any of the following specifications are valid:

DDF_COMPATIBILITY=DISABLE_IMPCAST_NJV
DDF_COMPATIBILITY=IGNORE_TZ
DDF_COMPATIBILITY=(SP_PARMS_NJV,SP_PARMS_JV)
DDF_COMPATIBILITY=(DISABLE_IMPCAST_NJV,DISABLE_IMPCAST_JV)
DDF_COMPATIBILITY=(DISABLE_IMPCAST_NJV,SP_PARMS_NJV,DISABLE_IMPCAST_JV)

You can specify the following values for DDF_COMPATIBILITY:

null
The DDF_COMPATIBILITY parameter has no effect and DB2 10 new function behavior is used for all applications.
Start of changeDISABLE_ITTO_EXCPTNEnd of change
Start of changeSpecifies that the DB2 for z/OS server does not send serviceability information to clients for idle thread timeout conditions.

DISABLE_ITTO_EXCPTN is deprecated.

End of change
DISABLE_IMPCAST_JV
Specifies that the DB2 for z/OS server 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 Java client application that uses the IBM® Data Server Driver for JDBC and SQLJ.

If DISABLE_IMPCAST_JV 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.

DB2 uses DISABLE_IMPCAST_JV only in DB2 10 new-function mode. In DB2 10 conversion mode,DB2 does not do implicit casting.

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.

DB2 uses DISABLE_IMPCAST_NJV only if DB2 is in DB2 10 new-function mode. If DB2 is in DB2 10 conversion mode, DB2 does not do implicit casting.

Start of changeIDNTFY_V10_PRIOR_VEREnd of change
Start of changeSpecifies that a DB2 for z/OS server in DB2 10 conversion mode identifies itself to all remote clients as one of the following servers:
  • A DB2 for z/OS server in DB2 9 new-function mode, if migration was from DB2 9
  • A DB2 for z/OS server in Version 8 in new-function mode, if migration was from Version 8
End of change
Start of changeIGNORE_TZEnd of change
Start of changeSpecifies that the time zone information is ignored in the 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.

End of change
SP_PARMS_JV
Specifies that when a Java client application calls a DB2 for z/OS stored procedure, DB2 returns output argument values with data types that match the data types that were specified in the CallableStatement.registerOutParameter method calls.

If SP_PARMS_JV 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_JV is deprecated.

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: DB2 does not return output argument values with data types that match the data types of the corresponding CALL statement arguments if either of the following conditions is true:
  • The non-Java client is Version 10 or later.
  • The stored procedure uses a parameter data type that was introduced in DB2 10 (XML, TIMESTAMP WITH TIMEZONE, or TIMESTAMP with precision greater than 6).

If either condition is true, DB2 returns output parameter values with data types that match the data types of the parameters in the stored procedure definition.

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.