Resource registry in MDQ WTX 8.1.0.2

[EDIstella]

Hi,

I need help. Currently we have 3 environments TEST , QA and production. Each of them has a separate database TEST1, QA1 and PROD2

Is there any way to implement resource registry variable in the MDQ for connect string? We are using WTX 8.1.0.2 in UNIX environment

That is if I can mentioon %MY_DB% in the connect string of MDQ and only change the configuration file to point to TEST< PROD or QA server?

Really need this information!!
Stella

[janhess]

I believe you can only use resource variables if you pass all the variables as parameters rather than using the mdq.

[EDIstella]

Hi janhess,

I did the following in the map ruleand it works:

=DBLOOKUP("select MER_BAL.SEQ_FILE_NO.nextval from dual" , "-DBTYPE ORACLE -CONNECT %Oracle01_DBNAME% -USER %Oracle01_Userid% -PASSWORD %Oracle01_Password%")

Yeah I agree it doesnt work at the mdq level.

Thanks for your inputs!