Previous Topic: -206 - OP2 NOT ALLOWED IF OP1 IS A TIMESTAMP FOR SCALAR FUNCTION CHARNext Topic: -208 - CASE EXPRESSION MUST CONTAIN AT LEAST ONE NON-NULL RESULT EXPRESSION


-207 - RESULT DATATYPES IN CASE/COALESCE/NULLIF EXPRESSION ARE INCOMPATIBLE

Explanation

The result expressions must all be able to be converted to some common type.

The SQLSTATE that equates to this SQL return code is 42804.

User Response

See the information on data types in the CA Datacom/DB SQL User Guide for details about data type compatibility.