CURRENT APPLICATION COMPATIBILITY
CURRENT APPLICATION COMPATIBILITY specifies the application compatibility level support for dynamic SQL statements in packages.
The data type is VARCHAR(10).
Set the value with the SET CURRENT APPLICATION COMPATIBILITY statement.
For packages, the initial value is determined by the value of the APPLCOMPAT bind option. For a user-defined functions or stored procedures, the initial value is inherited according to the rules in Special registers in a user-defined function or a stored procedure. For advanced triggers, the initial value is V12R1.
The following CURRENT APPLICATION COMPATIBILITY values are supported to specify the application compatibility behavior of dynamic SQL statements:
- Compatibility with the behavior of the identified Db2 function level. For example,
V12R1M510specifies 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.
- Compatibility with the behavior of Db2 12 function level 500. This value this value has the same result as specifying
- Compatibility with the behavior of Db2 11 new-function mode. After migration to Db2 12, this value has the same result as specifying
- Compatibility with the behavior of DB2® 10 new-function mode.
EXEC SQL SET :CS = CURRENT APPLICATION COMPATIBILITY;