Using a global variable

[Joseph_BERTHE1]

Hi,

In my development environment I have two database schemas one call AAA and the second call BBB.

We have only one scenraio which use BBB. It means that all my SQL queries are set with : select * from BBB.mytable

The problem is in qualification and production environment the schema is AAA.

My question, How can i use a global variable which is set to BBB for developement and AAA otherwise ?

Thanks

[Shabarish_Nair]

Note that parameters in the Communication channel are editable when transported to QA or PRD.

So ideally it is a practice to edit the table name to accommodate QA and PRD requirement.