KFAA30197-E
The data types of the aa....aa specified in the bb....bb are not compatible. (list number = cc....cc, query number = dd....dd) (M+J+O)
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.
-