Thank you Pedro. It's working!

Hello,

Yes I can see the Output in tLogRow. How can I use tJavaRow to assign variables?

I tried to create new variables in my context but I can't see them in my job. I only find the connection variables from the context.

I tried a simple test with an existing variable success:
tJavaRow:   context.myDB_AdditionalParams  = input_row.myFirstValue
Run IF condition:    context.myDB_AdditionalParams == "value"


What I'm doing wrong? Why context in the job it's updated with the new Variables?  I notice that my job use a context with 2 groups DEV and PROD and I only saw the Default (DEV).


If I use this variable in 2 jobs running at the same time I need more variables? They are local to the job or Global?


Rergards.

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.