topic Re: How to change context variables permanently after job execution in Talend Studio

How to change context variables permanently after job execution

Anonymous — Sat, 16 Nov 2024 07:21:48 GMT

Hi,

There is a field called "value" which has to be incremented for every execution of job. I wanted to increment it and set to context variable permanently, so that the new value is used in next job execution.

Is this possible? If yes, Can anyone guide me doing this?

Thanks,

Meghana.

Re: How to change context variables permanently after job execution

fdenis — Fri, 02 Nov 2018 09:18:12 GMT

its possible.
Add a to job who read this file, run your job using tRunJob (adding value into context) and write e new file.

but the best way is to store this value into a db using sequence.
Regards,

Re: How to change context variables permanently after job execution

TRF — Fri, 02 Nov 2018 09:57:28 GMT

Search for "implicit context" or "tContextLoad" to discover how to get context variables from an external file.
From there it's quite easy to do what you want.

Re: How to change context variables permanently after job execution

fdenis — Mon, 05 Nov 2018 10:39:18 GMT

did you solve your problem?

Re: How to change context variables permanently after job execution

Anonymous — Mon, 05 Nov 2018 13:52:02 GMT

hi Meghana,

since the requirement would not allow any variable creation within the job for such scenario , thus its better you go for counter value fetch from any database's table or from any file at the start of job and at the end of the job update that table or file with increment in its last value.

Regards

Chandra Kant

Re: How to change context variables permanently after job execution

Anonymous — Thu, 08 Nov 2018 06:05:22 GMT

Is it the only possible way..?

Can't we store somewhere in our job..?

Thanks!

Re: How to change context variables permanently after job execution

Anonymous — Thu, 08 Nov 2018 07:06:38 GMT

storing somewhere within the job means that variable needs to be created and initialized within the job and this will execute every time you run the job thus making it difficult to work as counter for job execution.

It would be better to use variable value from outside the job be it using file or table or tcontextload.

the flow could be read the value--> task --> update the value.

Regards

Chandra Kant

Re: How to change context variables permanently after job execution

Anonymous — Thu, 08 Nov 2018 07:18:33 GMT

Thank you