Dynamic SQL

, ,
1

hi all,

i want create a Dynamic SQL.
the Query will be like this.

“Select field1 form TableName where field2=blank”

but here i have to pass the TableName as an input as i am getting this TableName from the output of another adapter service output.

i know that i have to take two inputs as TableName and field2 and output as field2.
i ahve given the same names what i have given in the Query
but its giving error.

i think the query format what i am giving is not correct.
can u plz help me out in this by giving me the query.

thanks,
sree.

2

Hi,
What you can do is first create a dynamic sql adapter service with the following syntax “select field1 from {selectclause}” and also create the output parameters.
In the flow service after getting the table name from the other adapter service, create a string variable and concat the table name with the where clause. and pass it to the input of this dynamic sql adapter service.
This should solve yr problem.

3

whats the error?