Previous Topic: -207 - RESULT DATATYPES IN CASE/COALESCE/NULLIF EXPRESSION ARE INCOMPATIBLENext Topic: -209 - operation DISALLOWED ON object

SQL Codes › SQL Return Codes -1 through -999 › -208 - CASE EXPRESSION MUST CONTAIN AT LEAST ONE NON-NULL RESULT EXPRESSION

-208 - CASE EXPRESSION MUST CONTAIN AT LEAST ONE NON-NULL RESULT EXPRESSION

Explanation

Without any non-null result expressions, the CASE expression is not needed and has the same effect as specifying NULL.

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

User Response

Replace the CASE expression with NULL, or include a non-null result expression.