SQL Statements › PREPARE › Rules for Parameter Markers

Rules for Parameter Markers

A parameter marker is a question mark (?) that is used in place of a host variable in dynamic statements. Parameter markers must not be used:

• In an ESCAPE clause.
• In a select list.
• As an operand of the concatenation operator.
• As both operands of an arithmetic or comparison operator.
• As an operand in a date/time arithmetic expression.
• As the first operand of a LIKE predicate.
• As the first operand of a NULL predicate.

At least one of the operands of a BETWEEN or IN predicate must not be a parameter marker.

An argument of a scalar function cannot be specified solely as a parameter marker.

A parameter marker can be the operand of a unary minus operator.