Parameter within Parameter Value

[cuckoo]

Hi,

I have a parameter set P_Table which has a parameter called p_query.
The value of p_query is set to

SELECT A.*
FROM
#$evODS_OvrDB#.#$evODS_OvrSch#.xyz AS CTRL,
abc A
where A.header_id=ctrl.header_id

Please note that #$evODS_OvrDB# , #$evODS_OvrSch# are two user defined project level params.

In the actual parallel job, within the ODBC connector, I am setting SQL_STATEMENT to P_Table.p_query . This is not working though. Its not substituting the parameter values for the user defined parameters.
If i substitute the values then it works.

Does parameter within parameter not work?
Is there any other alternative i can use instead?
Please suggest.


Thanks in advance

[jerome_rajan]

No. Highly doubt that

[chulett]

Does parameter within parameter not work?

Correct - it does not work.

You would need to build the parameter string with the values substituted before passing it as a parameter. That or just pass the parameters as parameters and bind them into existing SQL. Does the source SQL really need to be 'dynamic'?

[cuckoo]

Thank you craig ! I used Ereplace to convert ,the Dynamic SQL. It works now!
Big thank you :D