I have a prepared sql statement and need to encode question marks that appear in strings..

for example
select * from topics where status=? and name="test?"

i need to encode the question mark in the string test? otherwise db2 thinks this statement requires two parameters, vs one

Have you tried using single-quotes, which are the standard SQL string delimiters?

hi stolze...this was just an example I should have used single quotes instead of double..problem still remains...

select * from topics where status=? and name='test?'

You could of course use and pass the text "test?" as a second parameter.
Is that an option for you?

select * from topics where status=? and name like 'test'||?

I haven't tried this myself, but my first assumption would be that it simply works as you expect, i.e. the 2nd '?' nested inside the string is not considered to be a parameter marker. If my assumption is wrong, please provide the DB2 version you are using (on which platform) and the exact error message that you are getting.