| |
- Causa
- Option SPECIFIED ON ALTER STATEMENT FOR routine-name (routine-type) IS NOT VALID.
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.
- Ação do sistema
- The statement cannot be processed.
- Resposta ao Desenvolvedor
- 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
© Copyright IBM Corp.
|
| |
