KFAA31245-E
There is an error in the specification method of an array element reference. (reason = aa....aa, query number = bb....bb) (M+J+O)
The specified array element reference is invalid.
- aa....aa: Invalid cause
-
Value of aa....aa
Description
SQLSTATE
the array value expression is not array data
The array value expression is not array data.
427P1
a dynamic parameter is specified in an array value expression
A dynamic parameter has been specified in an array value expression
427P2
specified position of the array element reference is invalid
The specified position for the array element reference is invalid.
427P3
column specifications of different table references are specified in a predicate that includes an array element reference for which ANY is specified
A different table reference column specification is being specified for a predicate that includes an array element reference with ANY specified.
427P4
a scalar subquery is specified in a predicate that includes an array element reference for which ANY is specified
A scalar subquery is specified for a predicate containing an array element reference with ANY specified.
427P5
column specifications of different table references are specified for an array element reference that has the same identification number and for which ANY is specified
A column specification for an array element reference that specifies ANY with the same identification number is specified for a column specification of a different table reference.
427P6
more than 255 types of identification numbers of array element references for which ANY is specified
The total number of the specified array element reference identification numbers specifying ANY specified in the SQL statement exceeds 255.
427P7
- bb....bb: Position number of the query that specified the array element reference
-
For details about query position numbers, see 1.5 Query position numbers.
However, if the value of SQLSTATE for aa....aa is 427P7, three asterisks (***) are displayed.
- S:
-
Ignores this SQL statement. Alternatively, the system invalidates this transaction.
- Action:
-
See Specification format and rules for array element references in the manual HADB SQL Reference and correct the SQL statement.