I am trying to create a workflow where the output from one SQL query from SQL Server can use as a parameter in other input SQL queries of IBM DB2.
I am able to achieve this using an interface tool. Interface tool creates a dependency of the user which can be executed until the user selects from the drop-down. Can we create the same logic without the interface tool?
Activity Performed - 1. SQL Server connected in Drop Down and Output from the query is used as a parameter in InPut Tool.
Requirement - Need to create logic without manual input in the drop-down. Workflow should be executed directly.
Solved! Go to Solution.
Hi @Jafar
You can use the batch input macro to do it. You will have your first db connection, filter/select the parameter and then pass the parameter to the macro, so it can update your second database connection.
MAIN WORKFLOW:
BATCH INPUT MACRO:
@Jafar could you not just replace the '20230104' in
where RG36.G36DTE > '20230104'
With a sub-query that runs the initial SQL query/select statement?
Both SQL Query are on different platforms. Subquery works on same platform database
Ah had overlooked that sorry! Then a batch macro as mentioned above should do it.