Start of change

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.

The following CURRENT APPLICATION COMPATIBILITY values are supported to specify the application compatibility behavior of dynamic SQL statements:

V11R1
Specifies Db2 11 application compatibility behavior. This value is supported only in Db2 11 new-function mode.
V10R1
Specifies Db2 10 compatibility behavior.
Example: Set the host variable CS to the compatibility level.
  EXEC SQL SET :CS = CURRENT APPLICATION COMPATIBILITY;
End of change