I am new to TDA and would like to automate the following using the automation capabilities of TDA 2.7:
I have a SQL Query that would pull some data from DB2 Subsystem on mainframes.
This query will have two parameters that should be read from a spreadsheet containing the list of values in column A & B.
The query should execute by reading param 1 from column A in excel and param 2 from column B in excel and append the result of the query for each parameter combination to an output excel spreadsheet.
Can anyone help me in this regard?
Appreciate any help on this matter at the earliest.