Hitachi

Hitachi Advanced Database Messages


KFAA30117-E

The number of aa....aa is not equal to the number of bb....bb. (query number = cc....cc) (M+J+O)

The number of aa....aa is not equal to the number of bb....bb. <SQLSTATE:42720>

aa....aa:
  • insert values: Insertion values

  • derived column list: A derived column list

  • "WITH" column list: A WITH column list

  • row value constructor elements on left side of the predicate: Row value constructor elements on the left side of the predicate

bb....bb:
  • insert columns: Insertion columns

  • derived columns: Derived columns

  • row value constructor elements on right side of the predicate: Row value constructor elements on the right side of the predicate

cc....cc: Position number of the query that specified the derived column list or row value constructor

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

If the error did not occur in a derived column list or row value constructor, the position number of the query will be 0.

S:

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

Action:

Correct the SQL statement.