Talend community forum / [resolved] Set a SQL result as a global var

nSmolyniec · 2009-06-08 15:05:27

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

Last edited by nSmolyniec (2009-06-09 10:47:24)

Phil34 · 2009-06-08 16:10:38

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

shong · 2009-06-08 16:21:47

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

nSmolyniec · 2009-06-08 16:52:18

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

Last edited by nSmolyniec (2009-06-08 16:52:32)

shong · 2009-06-09 04:18:25

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

Uploaded Images

nSmolyniec · 2009-06-09 10:07:46

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

shong · 2009-06-09 10:20:24

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

nSmolyniec · 2009-06-09 10:46:31

Hi again,

Ok, I'm going to try it.
Thank you much Shong.

Best regards,

Nicolas

Announcement

Unanswered posts

#1 2009-06-08 15:05:27

[resolved] Set a SQL result as a global var

#2 2009-06-08 16:10:38

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

#3 2009-06-08 16:21:47

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

#4 2009-06-08 16:52:18

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

#5 2009-06-09 04:18:25

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

#6 2009-06-09 10:07:46

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

#7 2009-06-09 10:20:24

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

#8 2009-06-09 10:46:31

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

Board footer