Start of change

-20467 THE STATEMENT WAS NOT EXECUTED BECAUSE AN EXPRESSION IS NOT A CONSTANT OR VARIABLE. THE INVALID EXPRESSION IS IN THE STATEMENT NEAR THE SYNTAX ELEMENT syntax-element

Explanation

The expression in the statement near the syntax element syntax-element must result in a single value, and must consist of one of the following elements:

  • A constant
  • A special register
  • A parameter marker
  • A variable
  • A deterministic function with no external action
  • An expression whose operands are any of the above elements

The expression cannot include any of the following elements:

  • A column name
  • A non-deterministic function
  • A function with external action
  • An expression whose operands are any of the above

System action

The statement cannot be processed.

User response

Change the statement to specify an expression that results in a single value, and contains only elements in the list of allowed elements. Issue the statement again.

SQLSTATE

428H7

End of change