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
