Background documentation-8006: Data types must be compatible Locate this document in the navigation structure

 

Explanation

  1. A function was applied to a non-permitted argument.

  2. A two-digit operation was applied to non-comparable values.

  3. A predicate contains non-comparable data types.

Each data type can be compared to itself. Columns of data type CHAR with the different ASCII and EBCDIC code attributes can be compared to each other, whereby they are implicitly adapted. Columns with ASCII codes attribute can be compared to date, time, and timestamp specifications. All numbers can be compared to each other.

User Response

Use a QUERY statement issued on the DOMAIN.COLUMNS system table to determine the definition of the affected columns. You may like to try to achieve comparability by using a conversion function.

More Information

SQL Reference Manual, Functions: Overview, Data Type.