logo  
Google
 

DB2 SQL-Error: -401

SQLState: 42818

Short Description: 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 a field procedure exists on one of the columns. If one column of arithmetic or comparison operation is defined with a field procedure, other columns in the operation must be defined with the same field procedure. System action: The statement cannot be executed. Programmer response: 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.

 <-  BACK TO INDEX