topic Re: Run If Condition Statements in Talend Studio

Run If Condition Statements

Anonymous — Thu, 04 Oct 2012 14:06:30 GMT

Good Afternoon,
I hope you will pardon what might be a daft question.
I have 2 tOracleSP components. The returned result of the first SP determines if the second SP gets run or a separate block of components do.
What I'd like to achieve is:
--- tOracleSP_1 --- Run If (tOracleSP_1.returned value == 0) --- tOracleSP_2
--- Run If (tOracleSP_1(returned value != 0) --- Some other component.
My problem seems to be how to access the returned value from the SP. Can anyone advise?.
Regards.
Nobby.

Re: Run If Condition Statements

alevy — Fri, 05 Oct 2012 05:33:04 GMT

Give tOracleSP_1 a schema column and use it for the "Is Function / Return result in" option. Pass a row from tOracleSP_1 to tSetGlobalVar to store the returned value in the globalMap. Hang the RunIfs off tSetGlobalVar, checking the globalMap variable as your condition.

Re: Run If Condition Statements

Anonymous — Fri, 05 Oct 2012 09:06:21 GMT

Alevy,
Thank you for the reply.
To get this part of my job working I had done exactly that!. Would I be correct in assuming the "Run If" trigger can not access a parent's variables directly?.
Regards.
Nobby.

Re: Run If Condition Statements

Anonymous — Fri, 05 Oct 2012 10:06:25 GMT

Hi NobbyHall
Not exactly, there are global variables of component (such as number of lines in an input component) and there is a result of component.
first ones are global variables of your job and the if link can access them (see the outline view on your studio).
the second ones are result of an execution and generally they can be put on data flow, they're not really variables unless we put them on variables such as suggested by alevy with the component tSetGlobalVar, once they're set as global variables the if link can directly access them (as variables not as data flow)