topic Re: How to pass parameter to tMysqlSP component in Talend Studio

How to pass parameter to tMysqlSP component

_AnonymousUser — Thu, 11 Oct 2012 20:34:22 GMT

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

Re: How to pass parameter to tMysqlSP component

Anonymous — Fri, 12 Oct 2012 06:11:52 GMT

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

Re: How to pass parameter to tMysqlSP component

_AnonymousUser — Fri, 12 Oct 2012 18:28:08 GMT

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

Re: How to pass parameter to tMysqlSP component

_AnonymousUser — Mon, 15 Oct 2012 17:29:05 GMT

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?

Re: How to pass parameter to tMysqlSP component

Anonymous — Mon, 15 Oct 2012 20:47:57 GMT

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