Hitachi

Hitachi Advanced Database Messages


KFAA30448-E

At least one "THEN" operand in searched CASE must be a value expression. (query number = aa....aa) (M+J+O)

A value expression must be specified for at least one of the THEN operands specified in a CASE expression. <SQLSTATE: 42784>

aa....aa: Position number of the query that specified the CASE expression that contains the error

For details about query position numbers, see 1.5 Query position numbers.

S:

Ignores this SQL statement. Alternatively, the system invalidates this transaction.

Action:

Correct the SQL statement.