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.
- DISABLE_ITTO_EXCPTN
- Specifies that the DB2 for z/OS server does
not send serviceability information to clients for idle thread timeout
conditions.
DISABLE_ITTO_EXCPTN is deprecated.
- 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.
- IDNTFY_V10_PRIOR_VER
- Specifies 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
- IGNORE_TZ
- Specifies 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.
- 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.