Query parameter in file

[Ven6]

hello dear all
I have a problem I would like to configure a query so that the parameters of the query are in a file on my computer.

I use a tAS400Row and the query is as follows: select * from table where date =? and name = '?'
I would like them? be read to a file on my computer.

plz help.

[manodwhb]

Read the parameters in a file and read using tfileinputdelimited and then use tflowtoiterate component after that use tAS400row and with the global variable of tflowtoiterate construct the query.

[TRF]

Construct the query as a sting like this:

"select * from table where date = " + (String)globalMap.get("theDate") + " and name = '" + (String)globalMap.get("theName") + "'"

Global variables theDate and theName must be pupulated after reading the file where the values are:

tFileInputDelimited-->tFlowToIterate

For tFlowToIterate, untick the option "Use the default (key, value) in global variables"  the add 2 rows to define these variables or let the option as is and use the autogenerated names such as row1.theDate and row.theName.