parameterisation problem
Posted: Thu Jan 20, 2011 7:36 am
Hi All
I am facing a problem while parameterising the query. I have a requirement to paramaeterise the source query.
For Ex: - SELECT * FROM #$SCHEMA#.EMP
I am calling the total query in a job parameter. When I declared the parameter as a string the total query is considered as string which includes Schema value also.
I tried in the parameter sourcequery(my param name) as
SELECT * FROM '":$SCHEMA:"'.EMP
but it is not working...
can some one throw light on this.
Thanks
skumar
I am facing a problem while parameterising the query. I have a requirement to paramaeterise the source query.
For Ex: - SELECT * FROM #$SCHEMA#.EMP
I am calling the total query in a job parameter. When I declared the parameter as a string the total query is considered as string which includes Schema value also.
I tried in the parameter sourcequery(my param name) as
SELECT * FROM '":$SCHEMA:"'.EMP
but it is not working...
can some one throw light on this.
Thanks
skumar