Use Output from one input as parameter in SQL query

Jafar

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.

Input_SQL_Query_SCD.png

DropDown_SCD.png

Felipe_Ribeir0

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:

Batch Correct.yxmc