Hitachi

Hitachi Advanced Database Messages


KFAA31263-E

There is an error in the specification method of aa....aa predicate for which a row value constructor is specified. (reason = bb....bb, query number = cc....cc) (M+J+O)

The specification method of the aa....aa that specified a row value constructor is invalid.

aa....aa: Type of predicate that contains error
  • COMPARISON: A comparison predicate

  • IN: An IN predicate

bb....bb: Reason for error

Value of bb....bb

Description

SQLSTATE

a row value constructor can be compared with other row value constructors only

Row value constructors and non-row value constructors are compared. Row-value constructors can only be compared to row-value constructors.

427M2

the specified value of the row value constructor element is invalid

The specified value of the row value constructor element is invalid.

427M3

the specified position of the predicate is invalid

The specified position of the predicate is invalid.

427M4

the comparison operator is invalid

A comparison operator is invalid.

427M5

cc....cc: Position number of the query that specified the predicate

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.