DB2 SQL-Error: -390
SQLState: 42887
Short Description: THE FUNCTION SPECIFIC NAME IS NOT VALID IN THE CONTEXT IN WHICH IT OCCURS
A function resolved to a specific function that is not valid in the context where it is used. If specific-name is an empty string, then the function resolved to the built-in function identified by function-name. Some of the possible situations include: v A scalar or aggregate function is referenced where only a table function is allowed (such as in the FROM clause of a query). v A table function is referenced where only a scalar or aggregate function is allowed (such as in an expression, or in a SOURCE clause of a CREATE FUNCTION statement).System action: The statement cannot be executed. Programmer response: Ensure that the correct function name and arguments are specified and that the SQL path includes the schema where the correct function is defined. You may need to change the function name, arguments, SQL path (using SET CURRENT PATH or the PATH bind option), or change the context in which the function is used. Refer to Chapter 5 of DB2 SQL Reference for information on the use of functions.