topic [resolved] Set a SQL result as a global var in Talend Studio

[resolved] Set a SQL result as a global var

Anonymous — Sat, 16 Nov 2024 13:55:37 GMT

Hi everyone,
I would like to get the result of a SQL query (it is a sequence number), and set it as a global variable I could use in several child jobs.
How can I do that (under TOS 3.0.x) ?
Thank you in advance.
Best regards,
Nicolas

Re: [resolved] Set a SQL result as a global var

_AnonymousUser — Mon, 08 Jun 2009 15:10:38 GMT

Hi,
I do this task by using a tContextLoad componet on exit on tMap component.

Re: [resolved] Set a SQL result as a global var

Anonymous — Mon, 08 Jun 2009 15:21:47 GMT

Hello Nicolas
Do you want to pass a parameter dynamically to child job or pass a fixed one?

I would like to get the result of a SQL query (it is a sequence number)

Please give an example to explain this sentence
Best regardsg
shong

Re: [resolved] Set a SQL result as a global var

Anonymous — Mon, 08 Jun 2009 15:52:18 GMT

Hi,
In fact, I want to generate one unique number number each time I launch a job.
It is an occurence generated by a sequence : etl_seq_int_occurence_id.NEXTVAL.
It's useful for some logs.
I would like to keep this value in a global (or context) var.
I will pass this variable in context parameter to some child jobs.
Regards,

Nicolas

Re: [resolved] Set a SQL result as a global var

Anonymous — Tue, 09 Jun 2009 03:18:25 GMT

Hello
In father job, generate the unique number and set it to a global or context var. on tRunjob, pass the value of global or context var to a context var defined in child job.
In child job, define a context var which will be used to receive value on father job.
Best regards
shong

Re: [resolved] Set a SQL result as a global var

Anonymous — Tue, 09 Jun 2009 09:07:46 GMT

Hi Shong,
Thank you.
However, I don't know how to pass my SQL result to a global or context var.
I tried to link an "tOracleInput" to a "tSetGlobalVar" component, but I haven't found how to set the input data as a var, and I haven't found any global var to take my SQL query result.
Best regards,
Nicolas

Re: [resolved] Set a SQL result as a global var

Anonymous — Tue, 09 Jun 2009 09:20:24 GMT

Hello

However, I don't know how to pass my SQL result to a global or context var.

tOracleInput-->tJavaRow(globalMap.put("sequence", input_row.colName)
Best regards

shong

Re: [resolved] Set a SQL result as a global var

Anonymous — Tue, 09 Jun 2009 09:46:31 GMT

Hi again,
Ok, I'm going to try it.
Thank you much Shong.
Best regards,
Nicolas