| |
- Causa
- ALTER STATEMENT FOR AN SQL ROUTINE CANNOT BE PROCESSED BECAUSE THE OPTIONS CURRENTLY IN EFFECT (ENVID current-envid) ARE NOT THE SAME AS
THE ONES THAT WERE IN EFFECT (ENVID defined-envid) WHEN THE ROUTINE OR VERSION WAS FIRST DEFINED.
The ALTER statement attempted to alter a version of a routine when the environment settings in effect at the time of the ALTER statement were not
the same as when the version of the routine was first defined.
- current-envid
- The environment settings that are in effect at the time of the ALTER statement.
- defined-envid
- The environment settings that were in effect when the object was first defined.
To alter a version of a routine, the environment settings that are in effect when the ALTER PROCEDURE or ALTER FUNCTION statement is issued must
be the same as the environment settings that were in effect when the version of the routine was first defined (either with a CREATE or ALTER
statement for the SQL routine) if any of the following options are specified as part of the statement's option-list clause:
- QUALIFIER
- PACKAGE OWNER
- WLM ENVIRONMENT FOR DEBUG MODE
- OPTHINT
- SQL PATH
- DECIMAL if the value includes a comma
- Ação do sistema
- The statement cannot be processed.
- Resposta ao Desenvolvedor
- Specify the name of a routine that was created with the same environment settings in effect as the current settings, or do not specify the
options named above.
SQLSTATE: 530A4
© Copyright IBM Corp.
|
| |
