Need to pass Datastore as parameter to SQL built in function
I have rquirement that i have to pass Datastore name to SQL function dynamically because the table that we are trying to query may known only during run time and the table also might in different server. While i am trying to pass the datastore name through variable i am getting error like this ([Script:scr_intialization]
The script <scr_intialization> contains an invalid expression. Additional information: <For call to function <sql>, parameter number <1> must be a string, in single quotes, representing a datastore.>. (BODI-1111242)). Is There any way to run the SQL statement other than SQL function or any other alternate way to achieve this?