I have created static variable with DSN information and used that in the RPD connection pool DSN. Is there anyway I can update the value of that static variable with some script before deploying in other environments, without manually going to that variable and change the value.
or do you recommend any other simple/easy solution to get this implemented.