KFAA30450-E

A cardinality violation occurred in the query at query tree number bb....bb. Two or more results were found in aa...aa at query tree number bb....bb. <SQLSTATE: 21502>

               aa....aa:

                  SCALAR SUBQUERY: A scalar subquery

               bb....bb: Query tree number of subquery that had two or more results

                  A query tree number is used to identify each query tree output to access path information. For details about query tree numbers, see Example of displayed access path information in About access paths in the HADB Application Development Guide.

                  Note that if a set operation is specified for the subquery, the following query tree number is output.

                        Query tree number that is output in the first QUERY SCAN(QUERY query-tree-number) under the corresponding set operation specification (SET OPERATION) in access path information

               S:

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

               Action:

                  Correct the SQL statement so that there is no more than one subquery result.