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. The value of the APPLCOMAT subsystem parameter specifies the default value.

APPLCOMPAT
  • (VvvRrrMmmm )
  • (V11R1)
  • (V10R1)
On: Start of changeBIND SERVICE, End of change BIND PACKAGE, REBIND PACKAGE, and REBIND TRIGGER PACKAGE

Start of changeNot valid for REBIND of a native SQL procedure packageEnd of change

The following values can be specified:
Start of changeVvvRrMmmmEnd of change
Start of changeCompatibility with the behavior of the identified Db2 function level. For example, V12R1M510 specifies compatibility the highest available 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. End of change
Start of changeV12R1End of change
Start of changeCompatibility with the behavior of Db2 12 function level 500. This value 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.
Defaults:
Process Default value
BIND SERVICE The value of the APPLCOMPAT subsystem parameter
BIND PLAN N/A
BIND PACKAGE The value of the APPLCOMPAT subsystem parameter
REBIND PLAN N/A
REBIND PACKAGE Existing value. If there is no existing value, the APPLCOMPAT subsystem parameter is used.
REBIND TRIGGER PACKAGE Existing value. If there is no existing value, the APPLCOMPAT subsystem parameter is used.