how to run multiple sql statements

One Star

how to run multiple sql statements

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
Moderator

Re: how to run multiple sql statements

Hi,
This article about How to call a stored Procedure or function. Hope it will be helpful for you.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.