Hello,

I have to validate with a SP if a job can run. I create my simple job something like this toracleInput -> tmap -> Output.
Inside the same job i put put a tFixedFlowInput (with input parameters for SP) -> tOracleSP (with 2 output columns) and know I want to make a condition using this 2 columns to validate if my starting job can run.

tFixedFlowInput -> tOracleSP --IF --> tOracleInput -> tmap -> Output

I tried to use Run IF but I can't access tOracleSP output columns. Any ideas to resolve this?



I tried something else to:
tFixedFlowInput -> tOracleSP -> tMap (with the 2 output columns condition) -> tLogRow --IF-->  tOracleInput -> tmap -> Output

The IF conditions is works fine and it's something like ((Integer)globalMap.get("tLogRow_1_NB_LINE"))>0.

I think this solution is not "very smart"...but I don't know a better way to do it.


Finally one of my requisites it's use the 2 output columns from the tOracleSP during the initial Job : toracleInput -> tmap -> Output and with my workaround I can't do it.