topic Re: read sql query from table and execute it in Talend Studio

read sql query from table and execute it

karandama2006 — Tue, 23 Apr 2019 06:00:26 GMT

Hi ,

I'm working on a use case , we have some SQL queries inserted in a table and I want to read the SQL queries from the table row by row and execute them.
Then take the output and insert it in some table.

Wanted some help in getting started with this use case , which components to use ? what would be the flow?

Thanks,

Karan

Re: read sql query from table and execute it

manodwhb — Tue, 23 Apr 2019 07:03:34 GMT

@karandama2006 , check the below screenshot and below link.

tRun Job

https://community.talend.com/t5/Design-and-Development/Passing-a-value-from-a-parent-Job-to-a-child-Job/ta-p/21695

Re: read sql query from table and execute it

karandama2006 — Tue, 23 Apr 2019 11:47:49 GMT

Thank you very much , exactly what I wanted