What I am trying to do is, just reading a max value from ODBC stage, setting a Job variable to it in one stage and then using that Job Variable in some other stage.
I am setting a Job variable in a transformer stage through a simple routine - setID(Arg1) :
Code: Select all
max_tid = Arg1;
Ans = max_tid;
In the transformer stage, I am calling this routine while reading a single row from ODBC stage and passing that as an argument to this routine.
So ideally, that input should be set to the max_tid job variable.
But its not happening! I am using max_tid value in another transformer stage but its not giving me the changed value, instead its giving me the default value that I give before execution starts.
Please suggest.