KFAA30114-E
The use of the "aa....aa" predicate is invalid. (invalid factor = bb....bb, operand number = c, query number = dd....dd) (M+J+O)
The specification of predicate aa....aa is invalid. <SQLSTATE: 42561>
- aa....aa: Type of predicate that contains error
-
-
COMPARISON: A comparison predicate
-
BETWEEN: A BETWEEN predicate
-
QUANTIFIED: Quantified predicate
-
- bb....bb: Description of error
-
-
OPERAND: An option specification is invalid.
-
COMBINATION: A combination of options is invalid.
-
DATA TYPE: A data type is invalid.
-
- c: Position number of the invalid value expression
-
Displayed when bb....bb is OPERAND. Otherwise, * is displayed.
Every value expression specified in the predicate aa....aa is assigned a position number by order of specification, starting from 1. The position number of the invalid value expression is displayed in place of c. For example, if aa....aa is BETWEEN and c is 2, there is an error in the specification of the second value expression from the start of the BETWEEN predicate.
- dd....dd: Position number of the query that specified predicate aa....aa
-
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.