Create, set and update the value of a Variable

[Anonymous]

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 ?

[TRF · Accepted solution]

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