Start of change

-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

End of change