Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
In this job, I want to get the value of min(date) as conf_time, assign the conf_time value to my context variable and use the context_variable in where query statement in pegsprodcaf02 input file.
But when I run the job, it passes 1 row from tInformixInput_2 to tFlowToIterate_1 and 0 rows from pegsprodcaf02(second input file) to dhscbindbs01al_stage. I am sure that there are around 9000000 rows in the table after min(date).
So am I missing something like tJava? that this job is not working properly or is there a problem in the way context variables is defined and referenced? or my query in where statement is not right? Thanks!
In this job, I want to get the value of min(date) as conf_time, assign the conf_time value to my context variable and use the context_variable in where query statement in pegsprodcaf02 input file.
But when I run the job, it passes 1 row from tInformixInput_2 to tFlowToIterate_1 and 0 rows from pegsprodcaf02(second input file) to dhscbindbs01al_stage. I am sure that there are around 9000000 rows in the table after min(date).
So am I missing something like tJava? that this job is not working properly or is there a problem in the way context variables is defined and referenced? or my query in where statement is not right? Thanks!
