topic Re: Executing "SQL" statements in Talend Studio

Executing "SQL" statements

Anonymous — Thu, 23 Feb 2017 05:11:50 GMT

I am used to executing sql via components by other outputting data into CSVs or updating data via CSVs. I have never needed to run SQL commands that dont really send or return data like running "truncate" on table. Which component would be best for this?

Re: Executing "SQL" statements

vapukov — Thu, 23 Feb 2017 09:07:35 GMT

Think it is tMySQLRow (change MySQL for Your type of database),
if more than 1 command in same component - read about JDBC parameters specific for Your database

Re: Executing "SQL" statements

cterenzi — Thu, 23 Feb 2017 15:44:29 GMT

You can run multiple commands with a single database "Row" component by separating them with semicolons.

Re: Executing "SQL" statements

vapukov — Thu, 23 Feb 2017 19:35:08 GMT

cterenzi wrote:
You can run multiple commands with a single database "Row" component by separating them with semicolons.

in case of MySQL at least, in this case You must add
Additional JDBC Parameters "allowMultiQueries=true"