[resolved] Set a SQL result as a global var

[Anonymous]

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

[_AnonymousUser]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous · Accepted solution]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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