How to pass parameter to tMysqlSP component

[_AnonymousUser]

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

[Anonymous]

Hi
You can use tFixedFlowInput to generate the input value and pass it tMysqlSP, for exmaple:
tFixedFlowInput--main--tMySQLSP.

[_AnonymousUser]

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

[_AnonymousUser]

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?

[Anonymous]

Hi,
And Check this link hope it will help https://community.talend.com/t5/Design-and-Development/resolved-Tmap-Integer-with-Unix-epoch-time-co...
Regards,
Biruh