DB2 SQL-Error: -491
SQLState: 42601
Short Description: CREATE STATEMENT FOR USERDEFINED FUNCTION MUST HAVE A RETURNS CLAUSE AND THE EXTERNAL CLAUSE WITH OTHER REQUIRED KEYWORDS THE RETURN STATEMENT AND PARAMETER NAMES OR THE SOURCE CLAUSE
A required clause is missing in the CREATE for function function-name. v For an EXTERNAL function, specify EXTERNAL and one of the following: – LANGUAGE – PARAMETER STYLEv For an SQL FUNCTION, specify a RETURN statement, and a parameter name for each parameter. v For a user-defined SOURCE FUNCTION, specify the SOURCE class.System action: The statement cannot be processed. Programmer response: Add the missing clauses or statement, and reissue the failing statement.