| |
- Causa
- THE OPERANDS OF AN ARITHMETIC OR COMPARISON OPERATION ARE NOT COMPARABLE.
An arithmetic operation appearing within the SQL statement contains a mixture of numeric and non-numeric operands, or the operands of a comparison
operation are not compatible.
One reason for this error is that the comparison involves both character and graphic operands.
This combination of operands is not allowed for EBCDIC and ASCII data.
For Unicode data, this combination of operands is not allowed if a field procedure exists on one of the columns.
- Ação do sistema
- The statement cannot be executed.
- Resposta ao Desenvolvedor
- Check the data types of all operands to ensure that their data types are comparable and compatible with their usage in the statement.
If all the operands of the SQL statement are correct, then, if a view is being accessed, check the data types of all the operands in the view
definition.
SQLSTATE: 42818
© Copyright IBM Corp.
|
| |
