logo  
Google
 

DB2 SQL-Error: -475

SQLState: 42866

Short Description: THE RESULT TYPE OF THE SOURCE FUNCTION CANNOT BE CAST TO THE RETURNS TYPE OF THE USERDEFINED FUNCTION C E SQL SOURCE RETURNS

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. See the DB2 SQL Reference for details on casting between data types. System action: The statement cannot be executed. Programmer response: Change the RETURNS data type or the SOURCE function identified so that the

 <-  BACK TO INDEX