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.
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:
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.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema