-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