-245 THE INVOCATION OF FUNCTION routine-name IS AMBIGUOUS
Explanation
DB2® was not able to resolve the indicated function.
- routine-name
- The name of the function.
This situation can occur in the following circumstances:
- An untyped parameter marker is passed to a function and there are two or more possible candidate functions to resolve to during function resolution.
- DB2 cannot determine how to implicitly cast the arguments between string and numeric data types.
- DB2 is unable to resolve a function invocation using the promotable process or castable process of function resolution.
System action
The statement cannot be processed.
Programmer response
Correct the problem and reissue the statement. You might need to change the SQL statement, the definition of a function, or the user's SQL path.
SQLSTATE
428F5