topic Re: Query parameter in file in Talend Studio

Query parameter in file

Ven6 — Mon, 06 Apr 2020 07:56:25 GMT

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.

Re: Query parameter in file

manodwhb — Mon, 06 Apr 2020 08:11:47 GMT

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.

Re: Query parameter in file

TRF — Mon, 06 Apr 2020 08:13:30 GMT

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.