-4706 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
Explanation
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
System action
The statement cannot be processed.
User response
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
