Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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!!! 
Labels (2)
3 Replies
Anonymous
Not applicable
Author

hi,
create strored procedure it's not the job of Talend 0683p000009MA9p.png (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
Not applicable
Author

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
Not applicable
Author