You are not logged in.
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.
Have you gotten the correct output from tOracleSP? Can you see them with tLogRow?
If so, I think you can link tOracleSP with tJavaRow and save output values into two context variables.
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?
The expression of RUN-IF is wrong.
Besides, you'd better add context variable as the following image.