-20102   CREATE OR ALTER STATEMENT FOR ROUTINE routine-name SPECIFIED THE option OPTION WHICH IS NOT ALLOWED FOR THE TYPE OF ROUTINE

Explanation

An option was specified that is not allowed for the type of routine being created or altered.
  • MODIFIES SQL DATA is not allowed for table functions.
  • ALLOW PARALLEL is not allowed for table functions.
  • CARDINALITY is not allowed for non-table functions.
  • LANGUAGE SQL is not allowed for non-SQL functions or procedures.
  • LANGUAGE specifying something other than SQL is not allowed for SQL functions or procedures.
  • LANGUAGE JAVA is not allowed for table functions.
  • PARAMETER STYLE JAVA is not allowed for table functions.
  • STOP AFTER FAILURE, STOP AFTER n FAILURES, or CONTINUE AFTER FAILURE are not allowed for sourced functions or SQL functions.

System action

The statement cannot be processed.

Programmer response

Remove the option from the statement and reissue the failing statement.

SQLSTATE

42849