02-11-2013 10:21 AM
A BI/GRID deployment with a different environment for (DEV, QA and PROD). Each environment has it's own Teradata database. The problem I'm trying to overcome is the when doing explicit sql pass-through in EG 5.1 the database name is not inserted. So we have to manually insert the name as an option in the sql definition. This means we have to re-code every program and recreated the stored processes as we move from environment to environment.
What I want to do is have a golbal/environment variable that I can control within the MC and then use that in the EG/SQL code