I have used a context variable which has value "1". I'm using that variable as execution id in my job. So I want that context variable value to be increased for every time job runs.
@Shalini M , you take on subjob ok from main job and take tfixedflow get the context variable and the use tjavrow and increase the value and connect to tDBoutput and insert into that main table.
@Shalini M , you need to maintain a table or file, initially you will set the id as 1 ,which you will read and load to context variable and then you will use in your main process that variable once it is compilated successfully then you have to increase that value and insert into that table or a file.
@Manohar B, I'm maintain a table for this id. But, I want to know how to increase the count and store it in that table. So that I can use that context variable for my next run.
@Shalini M , you take on subjob ok from main job and take tfixedflow get the context variable and the use tjavrow and increase the value and connect to tDBoutput and insert into that main table.
you can use tPostjob in your job and in tDBOutput write an update query where you are updating the value by first selecting the existing value and then add one on it.
