Hitachi

Hitachi Advanced Database Messages


KFAA30137-E

The number of values in the IN predicate exceeds 30,000. (M+J+O)

The number of value expressions or row value constructors specified on the right side of an IN predicate has exceeded the upper limit of 30,000. <SQLSTATE: 427A2>

S:

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

Action:

The number of value expressions or row value constructors specified to the right of the IN predicate should not exceed 30,000. Correct the SQL statement, and then retry the operation.