ANL1009W PGM CANNOT DETERMINE THE COST OF STATEMENT: nnnnnnnn, SQLCODE = cccc. ONE OR MORE HOST VARIABLES CANNOT BE CORRECTLY SUBSTITUTED WITH MARKER. PARAMETER MARKERS (?) ARE ILLEGAL IN SOME EXPLAIN REQUESTS. Or, AN ILLEGAL SYMBOL HAS BEEN ENCOUNTERED WITHIN THE SQL. The statement is ignored and processing continues.

Explanation

One of several SQL error codes were encountered: -104, -312 or -314, all indicating an incompatibility with the parameter marker and statement processed. Explain does not allow ? to hold place on both sides of expression, as part of concatenation, and several other instances. SQL PA catches use of ? in the SELECT list, and that is corrected dynamically. The other uses of ? are not allowed. SQL PA does not cost this query, but continues to process others.