topic Re: Create, set and update the value of a Variable in Talend Studio

Create, set and update the value of a Variable

Anonymous — Thu, 01 Nov 2018 15:41:06 GMT

I have a query that might return 0 or 1.

If it returns 0 then I need to wait for 2 minutes and keep trying again till it returns 1.

Whats the best way to implement this logic ?

Re: Create, set and update the value of a Variable

TRF — Thu, 01 Nov 2018 16:47:26 GMT

I assume your query is from a tOracleInput.
tLoop (while with the condition (Integer)globalMap.getOrDefault("stop", 0) != 0) -->tOracleInput-->tSetGlobalVar (to set the "stop" variable with the result of the query)--if((Integer)globalMap.get("stop") == 0)-->tSleep(120)
That's the idea