-132   AN OPERAND OF value IS NOT VALID

Explanation

The operation value can be the LIKE predicate, the ESCAPE clause, the LOCATE scalar function, the LOCATE_IN_STRING scalar function, the POSITION scalar function, or the POSSTR scalar function. The operand or argument of value was not valid for one of the following reasons:
  • The match-expression operand of a LIKE or NOT LIKE predicate must be a string expression.
  • The pattern-expression operand of the LIKE or NOT LIKE predicate, or search-string argument of the LOCATE, LOCATE_IN_STRING, POSITION, or POSSTR function must be a string expression that can be specified by any one of the following:
    • A constant
    • A special register
    • A host variable (including a LOB locator variable)
    • A scalar function whose arguments are any of the above (though nested function invocations cannot be used)
    • A CAST specification whose arguments are any of the above
    • An expression that concatenates (using CONCAT or ||) any of the above
  • The source-string argument of the LOCATE, LOCATE_IN_STRING, POSITION, or POSSTR function must be a string expression that can be specified by any of the following:
    • A constant
    • A special register
    • A host variable (including a LOB locator variable)
    • A scalar function whose arguments are any of the above (though nested function invocations cannot be used)
    • A CAST specification whose arguments are any of the above
    • A column name
    • An expression that concatenates (using CONCAT or ||) any of the above
  • The escape-expression operand of the LIKE or NOT LIKE predicate must be a string expression that can be specified by any of the following:
    • A constant
    • A host variable (including a LOB locator variable)
    • A scalar function whose arguments are any of the above (though nested function invocations cannot be used)
    • A CAST specification whose arguments are any of the above

A LIKE predicate, ESCAPE clause, LOCATE scalar function, LOCATE_IN_STRING scalar function, POSITION scalar function, or POSSTR scalar function cannot be used with DATE, TIME, or TIMESTAMP.

System action

The statement cannot be processed.

Programmer response

Check and correct the syntax of the LIKE predicate, or LOCATE, LOCATE_IN_STRING, POSITION, or POSSTR scalar function.

SQLSTATE

42824