topic Re: Use context variable as input parameter for tMSSqlSP in Talend Studio

Use context variable as input parameter for tMSSqlSP

Anonymous — Mon, 17 Jun 2013 22:08:45 GMT

I have set a context variable in my main job and want to use it as a input parameter in my tMSSqlSP componenent. However it is not possible to use it there. How to do this?

Re: Use context variable as input parameter for tMSSqlSP

alevy — Tue, 18 Jun 2013 00:58:33 GMT

Your job design looks fine to me. What problem are you having exactly?

Re: Use context variable as input parameter for tMSSqlSP

Anonymous — Tue, 18 Jun 2013 03:30:32 GMT

Hi limsuser,
I have seen that you used tRunjob. Is there any child job in your job design? The tMSSqlSP is the child job in your last screenshot? Do you want to Pass a value from a parent Job to a child Job?
Best regards
Sabrina

Re: Use context variable as input parameter for tMSSqlSP

Anonymous — Tue, 18 Jun 2013 18:44:27 GMT

The problem is not that the context variables being available in my subjob, but how to pass them as input parameter to my stored procedure?
In the screenshot you can see the context variables are available, but i can't access them in my input parameter for my sp. They are NULL then

Re: Use context variable as input parameter for tMSSqlSP

alevy — Tue, 18 Jun 2013 23:48:59 GMT

tMSSqlSP uses values from the incoming row as the parameters, not context variables. You should use tFixedFlowInput to put your context variables into the row for tMSSqlSP.