-581 THE DATA TYPES OF THE RESULT-EXPRESSIONS OF A CASE EXPRESSION ARE NOT COMPATIBLE
Explanation
There is a CASE expression in the statement that has result-expressions (expressions
following THEN and ELSE keywords) that are not compatible. The data type of the
result-expressions might be incompatible because the CASE condition result data types are not
all:
- character
- graphic
- numeric
- date
- time
- timestamp
- binary string
If encoded in Unicode, character and graphic data types are compatible, however.
System action
The statement cannot be processed.
Programmer response
Correct the result-expressions so that they are compatible.
SQLSTATE
42804