logo  
Google
 

DB2 SQL-Error: -417

SQLState: 42609

Short Description: A STATEMENT STRING TO BE PREPARED INCLUDES PARAMETER MARKERS AS THE OPERANDS OF THE SAME OPERATOR

The statement string specified as the object of a PREPARE contains a predicate or expression where parameter markers have been used as operands of the same operator—for example: ? > ? This syntax is not permitted. System action: The statement cannot be executed. Programmer response: Correct the logic of the application program so that this syntax error does not occur. Refer to Chapter 5 of DB2 SQL Reference for information about the proper usage of parameter markers within SQL statements to be prepared.

 <-  BACK TO INDEX