Teradata Database Message 3771 - 3771 - Analytics Database - Teradata Vantage

Message

Illegal expression in WHEN clause of CASE expression.

Explanation

There are 3 auses of this error are: a) a boolean is specified in a WHEN clause for a simple CASE expression, Example: SEL CASE t.x WHEN 1=1 THEN t.x ELSE t.y END FROM t; b) a simple expression is specified in a WHEN clause for a conditional CASE expression, Example: SEL CASE WHEN 1+1 THEN t.x ELSE t.y FROM t; c) an embedded SELECT is found in the WHEN clause

Generated By

GNCEVL.

For Whom

The end user.

Notes

None

Remedy

Correct and re-submit SQL query.