-475 THE RESULT TYPE type-1 OF THE SOURCE FUNCTION CANNOT BE CAST TO THE RETURNS TYPE type-2 OF THE USER-DEFINED FUNCTION function-name

Explanation

In order for the CREATE FUNCTION for a sourced user-defined function to be valid, the result type (type-1) of the source function must be castable to the RETURNS type (type-2) of the function being created. There is no supported cast between these data types.

System action

The statement cannot be processed.

Programmer response

Change the RETURNS data type or the SOURCE function identified so that the result type of the SOURCE function is castable to the RETURNS data type.

SQLSTATE

42866