In this post, you’ll learn about the IBM DB2 Error -4706 and the reason why you are receiving it
IBM DB2 Error Code :
-4706
Reason for this Error in DB2
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