-4705 option SPECIFIED ON ALTER STATEMENT FOR routine-name (routine-type) IS NOT VALID
Explanation
An ALTER statement specified an option that is not valid for the type of routine.
- option
- The invalid option.
- routine-name
- The name of the procedure or function.
- routine-type
- The type of routine: procedure or function.
The valid options vary by routine type:
- PROCEDURE
- The options that can be specified when altering an SQL procedure depend on the type of the SQL procedure being changed. Two types of SQL procedures exist: native SQL procedures and external SQL procedures.
- FUNCTION
- The options that can be specified when altering an SQL scalar function depend on whether the SQL function is an inlined function or a compiled function.
System action
The statement cannot be processed.
User response
Review the appropriate ALTER statement to determine which options can be changed for the specified object, correct the syntax, and reissue the statement.
SQLSTATE
530A3