You can use database configuration parameters to indicate
whether the compatibility semantics associated with the certain data
types are applied to the connected database.
The compatibility parameters that can be
checked are:
- date_compat
- Indicates whether the DATE data type compatibility semantics that
are associated with the TIMESTAMP(0) data type are applied to the
connected database.
- number_compat
- Indicates whether the compatibility semantics that are associated
with the NUMBER data type are applied to the connected database.
- varchar2_compat
- Indicates whether the compatibility semantics that are associated
with the VARCHAR2 data type are applied to the connected database.
The value of each of these parameters is determined
at database creation time, and is based on the setting of the
DB2_COMPATIBILITY_VECTOR registry
variable. You cannot change the value.