When we run a query with syntax like 
SELECT foo FROM bar WHERE (lower(foo) LIKE lower(?))
from DBI we get the error
DBD::DB2::db prepare failed: [IBM][CLI Driver][DB2/LINUX] SQL0418N  A
statement contains a use of a parameter marker that is not
valid.  SQLSTATE=42610

The query without the LCASE works 
 SELECT foo FROM bar WHERE (lower(foo) LIKE ?).
 
Is this a limitation of DB2 (it works in Oracle) or is it an error
in DBD::DB2?

Thanks,
Belinda

Reply via email to