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
![Smile :)](./images/smilies/icon_smile.gif)