creating procedure in mysql

[Anonymous]

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!!! 

[Anonymous]

hi,
create strored procedure it's not the job of Talend (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 ?

[Anonymous]

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.

[Anonymous]

mySqlSP (as Stored Procedure)
https://help.talend.com/search/all?query=tMysqlSP&content-lang=en
regards