KFAA30197-E

The data types of aa....aa specified in bb....bb are not compatible. <SQLSTATE: 42804>

               aa....aa: Location of error

                        derived columns for each query: Derived columns for each query

                        element for each row value constructor: Row value constructor element for each row value constructor

               bb....bb: Corresponding item

                        set operation: Set operation

                        table value constructor: Table value constructor

               cc....cc: List number resulting in an error

                        If bb....bb is set operation: List number of the selection list for the derived table

                        If bb....bb is table value constructor: Number indicating the position where the relevant row value constructor element is specified

               dd....dd: Position number of the query that specified 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:

                        If aa....aa is derived columns for each query

                        Correct the SQL statement so that the data types indicated in aa....aa are compatible.

                        If aa....aa is element for each row value constructor

                        The data type of the i-th row value constructor element in each row value constructor is not comparable. Correct the specified row value constructors. For details, see Rules in Specification format and rules for table value constructors in the manual HADB SQL Reference.