In our environment schema names for DB tables change based on which environment(Dev,Systst,Inttst,Prod) is being accessed. Is there a way for the schema name to be dynamic between environments. Right now we need change the schema’s through the wizard in each environment. We would like to avoid this.
We are accessing DB2 on MVS(7.1) and UDB(8.x) running on AIX using the IBM type4 driver.
Thanks in advance for any suggestions.