15.00 - 3771 Illegal expression in WHEN clause of CASE expression. - Teradata Database

Teradata Database Messages

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1096-015K
Language
English (United States)

3771 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.

Remedy:

Correct and re-submit SQL query.