How to pass parameter to tMysqlSP component

One Star

How to pass parameter to tMysqlSP component

Hello,

I am working with a tMysqlSP component in my project and need to know how to pass numeric values to it. One of my component is executing a query to find out if a given table is empty. If so, I need to pass value 0 to procedure that will do nothing, otherwise it will perform some operations. Thank you in advance for any input you can provide.
Doug
Community Manager

Re: How to pass parameter to tMysqlSP component

Hi
You can use tFixedFlowInput to generate the input value and pass it tMysqlSP, for exmaple:
tFixedFlowInput--main--tMySQLSP.
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: How to pass parameter to tMysqlSP component

Thanks for the feedback. Do you happen to have any step by step instructions as well?
One Star

Re: How to pass parameter to tMysqlSP component

Hello,

Please let me know if you have any step by step instructions on how to implement your suggestion, or any articles I can look at to shed further light on this. Thanks.
Thanks for the feedback. Do you happen to have any step by step instructions as well?
One Star

Re: How to pass parameter to tMysqlSP component

Hi,
And Check this link hope it will help http://www.talendforge.org/forum/viewtopic.php?pid=15086#p15086
Regards,
Biruh