-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