How to execute/write multiple sql staments(Using MYSQL Connector) in BOOMI?
The database connector for mysql connection needs to have this "?allowMultiQueries=true".
I just tested inserting multiple rows in mysql database and it works fine.
Thanks and Good Luck!
Please elaborate. I don't think you asking how to combine the 3 sql into 1 query, but, rather you asking how to load 3 different record sets and use it in a process?
How can i achieve writing multiple sql statements in BOOMI
UPDATE table1 SET field1 =field1+1;UPDATE table1 SET field2 =field2+1;UPDATE table1 SET field3 =field3+1'
UPDATE table1 SET field2 =field2+1;UPDATE table1 SET field3 =field3+1'
UPDATE table1 SET field3 =field3+1'
Will it work if i write sql statemnts in database profile/Programcommand shape like below example
Yes it should work, I tested this in database profile.
Thank you Prashant. It will also work in Programcommand shape.
Retrieving data ...