-491 CREATE STATEMENT FOR USER-DEFINED FUNCTION function-name MUST HAVE A RETURNS CLAUSE AND: THE EXTERNAL CLAUSE WITH OTHER REQUIRED KEYWORDS; THE PARAMETER NAMES; OR THE SOURCE CLAUSE
Explanation
A required clause is missing in the CREATE for the specified function.
- function-name
- The name of the function.
System action
The statement cannot be processed.
Programmer response
Add the missing clauses, and reissue the failing statement.
For an EXTERNAL function, specify EXTERNAL and one of the following options:
- LANGUAGE
- PARAMETER STYLE
For a user-defined SOURCE FUNCTION, specify the SOURCE clause.
SQLSTATE
42601