Accessing Values from SetGlobalvar and tBufferOutput and Input
Hello,
i have the following problem, which is discussed here several times, but after reading these threads i cannot find a solution.
Description:
I want to share values between jobs.
As i read here, it is not possible to share these values with SetGlobalVar.
Some solutions here works with the tBuffer component.
So I put the values from Global into tBufferOutput.
If i understand it correctly, i can read this buffer in other jobs with tBufferInput, too!.
But i have no luck doing this.
Any idea?
Another solution is to put the values in context.
But how do i copy a globalvar into a context var?
Should i do this with tJava component?
Could i access these values all over my jobs?
Here are my screenshots of the main and childjob.
Hope it helps.
Best wishes
Jens
Hi Have you redesign the job as I suggested yesterday? Best regards Shong
hello,
yes i did.
screenshot below.
i changed the flow into an subjob and changed tjava into tjavarow.
What could i do further?
Any suggestions?
Best wishes
Jens
Hi
Change the job to:
tMysqlConnection
|
onsubjobok
|
tFileInputDeliited--main--tContextLoad
|
onsubjobok
|
tWaitForDate--itertate-->....
Best regards
Shong
Hi Change the job to: tMysqlConnection | onsubjobok | tFileInputDeliited--main--tContextLoad | onsubjobok | tWaitForDate--itertate-->.... Best regards Shong
Hi,
thanks for the tipp, but same result :-((
here is the code from tjavarow (i changed nothing from the above code)
context.put("dirty_datetime_last",input_row.dirty_datetime_last);
context.put("dirty_datetime_new",input_row.dirty_datetime_new);
context.put("aggregation_last",input_row.aggregation_last);
context.put("integration_last",input_row.integration_last);
context.put("date_from",input_row.date_from);
context.put("date_until",input_row.date_until);
context.put("kw_von",input_row.kw_von);
context.put("kw_bis",input_row.kw_bis);
context.put("tag_von",input_row.tag_von);
context.put("tag_bis",input_row.tag_bis);
context.put("monat_von",input_row.monat_von);
context.put("monat_bis",input_row.monat_bis);
context.put("jahr_von",input_row.jahr_von);
context.put("jahr_bis",input_row.jahr_bis);
context.put("stunde_von",input_row.stunde_von);
context.put("stunde_bis",input_row.stunde_bis);
context.put("anzahl",input_row.anzahl);
context.synchronizeContext();
and here is the screenshot.
Any clues?
Best wishes
Jens
