KFAA31128-E
The specification of the "FULL OUTER JOIN" is invalid. (reason = aa....aa , details = bb....bb) (M+J+O)
A FULL OUTER JOIN specification has the following error:
-
An external reference column whose reference destination is a table reference specified in FULL OUTER JOIN was specified. For details, see Common rules for subqueries in Rules in Specification format and rules for subqueries in the manual HADB SQL Reference. <SQLSTATE:427I8>
- aa....aa: Cause of the error
-
correlated subqueries: An external reference column was specified.
- bb....bb:
-
The column which refers to "Table Reference" in "FULL OUTER JOIN": A column that references a table reference specified in FULL OUTER JOIN was specified.
- S:
-
Ignores this SQL statement. Alternatively, the system invalidates this transaction.
- Action:
-
Correct the SQL statement.