USER_DEFINED_FUNCTIONS error class

User defined function is invalid:

CANNOT_CONTAIN_COMPLEX_FUNCTIONS

SQL scalar function cannot contain aggregate, window, or generate functions: <queryText>

CANNOT_REPLACE_NON_SQL_UDF_WITH_SQL_UDF

Cannot replace the non-SQL function <name> with a SQL function.

CORRELATED_REFERENCES_IN_SQL_UDF_CALLS_IN_DML_COMMANDS_NOT_IMPLEMENTED_YET

This command includes calls to SQL user-defined function <functionName> which contains subquery expressions with correlated outer references; this feature is is not implemented yet

NOT_A_VALID_DEFAULT_EXPRESSION

The DEFAULT expression of <functionName>.<parameterName> is not supported because it contains a subquery.

NOT_A_VALID_DEFAULT_PARAMETER_POSITION

In routine <functionName> parameter <parameterName> with DEFAULT must not be followed by parameter <nextParameterName> without DEFAULT.

NOT_NULL_ON_FUNCTION_PARAMETERS

Cannot specify NOT NULL on <languageName> function parameters: <input>

RETURN_COLUMN_COUNT_MISMATCH

The number of columns produced by the RETURN clause (num: <outputSize>) does not match the number of column names specified by the RETURNS clause (num: <returnParamSize>) of <name>.

SQL_TABLE_UDF_BODY_MUST_BE_A_QUERY

SQL table function <name> body must be a query.

SQL_TABLE_UDF_MISSING_COLUMN_NAMES

The relation returned by the query in the CREATE FUNCTION statement for <functionName> with RETURNS TABLE clause lacks explicit names for one or more output columns; please rewrite the function body to provide explicit column names or add column names to the RETURNS TABLE clause, and re-run the command.

SQL_UDF_RETURNS_CLAUSE

Must specify an explicit RETURNS clause for user-defined <functionType> function.

UNEXPECTED_ENVIRONMENT_SETTINGS

Unexpected environment settings for <languageName> user defined functions: <invalidKeys> (valid settings are: <validKeys>). Update the ENVIRONMENT clause and try again.