DB2 SQL-Error: -132
SQLState: 42824
Short Description: AN OPERAND OF IS NOT VALID
The operation value can be the LIKE predicate, the ESCAPE clause, the LOCATE 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: v The match-expression operand of a LIKE or NOT LIKE predicate must be a string expression. v The pattern-expression operand of the LIKE or NOT LIKE predicate, or search-string argument of the LOCATE, 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 abovev The source-string argument of the LOCATE, 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 abovev 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 aboveSee the DB2 SQL Reference for the rules of what can be specified in each context. A LIKE predicate, ESCAPE clause, LOCATE 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, POSITION, or POSSTR scalar function.