Database Schema configuration

[db2sachin]

I have a problem with queries. Actually our DB schema for development and UAT are different.
For eg. we use following query in our Development environment.

"Select * from DWSTG.CUST_PRDCT where GRP_MBR_ID= ? ;

but for UAT we need to change the schema to TMSTG.CUST_PRDCT from DWSTG.CUST_PRDCT

Could you please suggest if this schema is configurable somewhere in database setting or something. So that I don't need to change the code to incorporate different schema name (TMSTG) before deploying it on UAT.

 

[gregsimpson]

db2sachin,

access your table via an alias. Then all you need to do is change the alias definition throughout the promotion of your code, once per environment, rather than having to change all your code.

Cheers
Greg