Hitachi

Hitachi Advanced Database Messages


KFAA30447-E

The data types of a "THEN" or "ELSE" operand specified in a CASE expression are not compatible. (query number = aa....aa) (M+J+O)

The data types of the results of value expressions specified for THEN and ELSE in a CASE expression are not compatible. <SQLSTATE: 42806>

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.