50 DB2 Nuggets #50: Expert Advice: Troubleshoot DB2 CLI error: SQL0245N The invocation of routine "<routine name>" is ambiguous.
Subbu Prabhu 060001JD9S Visits (11582)
Hello, Recently I worked on another interesting case where an ODBC/CLI application using SUBSTRING(..., CODEUNITS32) and LOCATE(..., CODEUNITS32) functions in case when first argument is a parameter and the function is used in WHERE or HAVING clause expression resulted in error: [IBM][CLI Driver][DB2/NT] SQL0245N The invocation of routine "SUBSTRING" is ambiguous. The argument in position "1" does not have a best fit. SQLSTATE=428F5. This error is returned when an invocation of a function is ambiguous. This occurs when there... [More]