DSXchange

Hi,

Below is my requirement.

Execute a query by reading the query from a file in DB2 connector stage and writing to a sequential file.
But the catch is I have a where clause in the select query and pass parameters at run time to this where clause.
For example : where search_column like #PARAM#

Could anyone help me how can I implement this passing parameters to the query read from a file
I am not sure if we can do this in data stage.

Any suggestions or alternate approaches on this could be a great help.

You can't, at that point the parameters are just text. You need to build the file on the fly with the parameter values substituted in, ready to go.

Thanks Craig