how to run multiple sql statements

Anonymous — Sat, 16 Nov 2024 12:02:28 GMT

Hi,

urgent please.
i created a tMysqlRow and i also added the "Additional JDBC Parameters" to include "allowMultiQueries=true" but when i run the job only one query is getting updated i have a list of query please help me to resolve this issue
but the query's look as below with the tMysqlRow with properties "Additional JDBC Parameters" to include "allowMultiQueries=true"
i have enclosed the list of querys in double quotes.

"create table query;
insert query;
update query;
update query;
update query;
update query;
update query;
"
only one query is getting executed please help me to resolve this issue.
some members suggest to use sp component how to use a sp.please help me...
Thanks
caba

Re: how to run multiple sql statements

Anonymous — Fri, 03 May 2013 03:06:09 GMT

Hi,
This article about How to call a stored Procedure or function. Hope it will be helpful for you.
Best regards
Sabrina

topic how to run multiple sql statements in Talend Studio

how to run multiple sql statements

Re: how to run multiple sql statements