Ansicht
Dokumentation

SQL0417 - Combination of parameter markers not valid. ( OS/400 )

General Material Data   CL_GUI_FRONTEND_SERVICES - Frontend Services  
This documentation is copyright by IBM.


Message : SQL0417
Combination of parameter markers not valid.

Message Long Text :

Cause . . . . . : The statement string specified as the object of a PREPARE statement contains a predicate or expression where parameter markers have been used as operands of the same operator. The following restrictions apply to the use of parameter markers:
-- Both the operands in a predicate cannot be parameter markers. For example, specifying predicates of the form:
? = ?
or
? = ( SELECT ? FROM x )
are not valid.
-- Both the operands in a expression cannot be parameter markers. For example, specifying an expression of the form:
? + ?
is not valid.
-- At least one of the operands in the BETWEEN predicate cannot be a parameter marker. For example, specifying the predicate of the form:
? BETWEEN ? and ?
is not valid.
-- At least, one of the operands of the IN predicate must not be a parameter marker. For example, specifying the predicate of the form:
? IN (?, ?, ?)
is not valid.
Recovery . . . : Correct the statement so that all operands of the predicate or expression are not parameter markers. A CAST specification can be used in most cases to assign attributes to a parameter marker. Try the request again.

Message File : QSQLMSG
Library Message File : QSYS2924


General Material Data   Vendor Master (General Section)  
This documentation is copyright by IBM.

Length: 3253 Date: 20240424 Time: 070703     sap01-206 ( 2 ms )