creating procedure in mysql

One Star

creating procedure in mysql

Hello guys!
Could you please help me to figure out if it's possible or not to create stored procedure within a Talend Job? and i  am using MySQL server as back end ,in my job i used tsqlscriptparser component is iterated to tmysqlrow component and i fail to create stored procedure in MySQL DB,please help me, I'll be very grateful for an example.
Thank you a lot in advance!!! 
Seventeen Stars

Re: creating procedure in mysql

hi,
create strored procedure it's not the job of Talend Smiley Wink (even if you can by using mysqlRow)
https://dev.mysql.com/doc/refman/5.0/en/create-procedure.html
But Talend  can easely use them :
https://help.talend.com/search/all?query=Calling+a+stored+procedure+or+function&content-lang=en
 example on Oracle DB but the same for Mysql
hope it helps
regards
laurent
ps : why do you say : "i fail to create stored procedure in MySQL DB" ??
what do you mean ?
One Star

Re: creating procedure in mysql

Hey Thanks for the reply,
I have writen  Mysql statement script that create procedure i want to know which component should i use in talend.
Seventeen Stars

Re: creating procedure in mysql