DB2 SQL-Error: -575
SQLState: 42804
Short Description: C THE DATA TYPES OF THE RESULTEXPRESSIONS OF A CASE EXPRESSION ARE NOT COMPATIBLE
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: v character v graphic v numeric v date v time v timestamp If encoded in Unicode, character and graphic data types are compatible, howver. Refer to DB2 SQL Reference for more information about Unicode. System action: The statement cannot be processed. Programmer response: Correct the result-expressions so that they are compatible.