Hitachi

Hitachi Advanced Database Messages


KFAA30195-E

The derived tables for a set operation must have the same number of columns. (M+J+O)

In a specified set operation, the tables derived from individual query expression bodies do not have the same number of columns. <SQLSTATE: 42721>

S:

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

Action:

Correct the SQL statement so that the tables derived from individual query expression bodies have the same number of columns. For details, see Rules for set operations in Rules in Specification format and rules for query expressions in the manual HADB SQL Reference.