KFAA30188-E
There is an error in the specification method of a collection derived table. (reason = aa....aa, query number = bb....bb) (M+J+O)
The specified collection derived table is invalid. <SQLSTATE:4275A>
- aa....aa: Reason
-
-
one or more column specifications are not array data:
The column specification is not array data.
-
one or more columns are not columns of a real table or a foreign table joined with the collection derived table by using a comma join:
One or more columns are not columns of a base table joined with the collection derived table by using a comma join. Or, one or more columns are not columns of a foreign table joined with the collection derived table by using a comma join.
-
column specifications of different tables are specified:
The column specification of a different table is specified.
-
- bb....bb: Position number of the query that specified the collection derived table
-
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.
For details about the rules for specification of collection derived tables, see Table references in the manual HADB SQL Reference.