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.
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.
- 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.
IGNORE_TZ is not needed and has no effect if the client JDBC driver is at version 3.63 or 4.13, or later.
- 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: 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.
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.