APPLCOMPAT bind option

The APPLCOMPAT option specifies the application compatibility behavior for static SQL statements in the package. It also sets the initial value of CURRENT APPLICATION COMPATIBILITY special register, which controls the application compatibility behavior for dynamic SQL statements in the package.

Command option Option values Used with
APPLCOMPAT
  • (VvvRrrMmmm )
  • (V11R1)
  • (V10R1)
Note:
  1. The APPLCOMPAT bind option is not valid for REBIND of packages for native SQL procedures or advanced triggers.

The following values can be specified:

Option descriptions for APPLCOMPAT

Start of change(VvvRrMmmm)End of change
Start of change

Compatibility with the behavior of the identified Db2 function level. For example, V12R1M510 specifies compatibility with the highest available Db2 12 function level. The equivalent function level or higher must be activated. For a list of supported Db2 12 function levels, see Db2 12 function levels.

Tip: Start of change Extra program preparation steps might be required to increase the application compatibility level for applications that use data server clients or drivers to access Db2 for z/OS®. For more information, see Setting application compatibility levels for data server clients and drivers.End of change
End of change
Start of change(V12R1)End of change
Start of changeCompatibility with the behavior of Db2 12 function level 500. This value has the same result as specifying V12R1M500.End of change
(V11R1)
Compatibility with the behavior of Db2 11 new-function mode. After migration to Db2 12, this value has the same result as specifying V12R1M100.
(V10R1)
Compatibility with the behavior of DB2® 10 new-function mode.

Default values for APPLCOMPAT

Process Default value
BIND SERVICE APPLCOMPAT subsystem parameter1
BIND PLAN N/A
BIND PACKAGE APPLCOMPAT subsystem parameter1
REBIND PLAN N/A
REBIND PACKAGE Existing value. If there is no existing value, the APPLCOMPAT subsystem parameter is used.1
REBIND TRIGGER PACKAGE Existing value. If there is no existing value, the APPLCOMPAT subsystem parameter is used.1
Note:
  1. The APPLCOMPAT subsystem parameter specifies the default value to use when the APPLCOMPAT bind option is not specified in a BIND command, or the APPLCOMPAT value is not specified or stored in the Db2 catalog for a REBIND command. Its value does not prevent specific applications from running at higher application compatibility levels. For more information, see APPL COMPAT LEVEL field (APPLCOMPAT subsystem parameter).