topic Re: [resolved] ((Integer)globalMap.get("tMSSqlOutput_2_NB_LINE_INSERTED")) in Talend Studio

[resolved] ((Integer)globalMap.get("tMSSqlOutput_2_NB_LINE_INSERTED"))

Anonymous — Fri, 23 Oct 2015 15:01:53 GMT

After an insert in a table in a SQLServer Database, I want to display the number of records inserted
So I use the global variable ((Integer)globalMap.get("tMSSqlOutput_2_NB_LINE_INSERTED"))
and I get Null as result.
I have check in the table the row is inserted!
Where is my misstake?
Thanks

Re: [resolved] ((Integer)globalMap.get("tMSSqlOutput_2_NB_LINE_INSERTED"))

Anonymous — Fri, 23 Oct 2015 15:28:32 GMT

Hi
Can you please upload a screenshot of job? I think there might be a job design issue here.
Best regards
Shong

Re: [resolved] ((Integer)globalMap.get("tMSSqlOutput_2_NB_LINE_INSERTED"))

Anonymous — Sun, 25 Oct 2015 19:41:32 GMT

Below the screenshot of the job:

((Integer)globalMap.get("tMSSqlOutput_1_NB_LINE_UPDATED")) are in the tMap_3 et tMap_4 components

Re: [resolved] ((Integer)globalMap.get("tMSSqlOutput_2_NB_LINE_INSERTED"))

Anonymous — Mon, 26 Oct 2015 17:08:18 GMT

No idea?????

Re: [resolved] ((Integer)globalMap.get("tMSSqlOutput_2_NB_LINE_INSERTED"))

Anonymous — Tue, 27 Oct 2015 04:04:32 GMT

Hi
It is not a bug, this kind of global variable should be used in next subjob, if you look into the generated code of job, you will see the the code ((Integer)globalMap.get("tMSSqlOutput_1_NB_LINE_UPDATED")) on tMap_3 is executed before putting value to the global variable in the end part of tMssqlOutput, so you need to change the job design, eg:
....tMSSQLOutput--tHashOutput
|
onsubjobok
|
tHashInput--main--tMap_3....

Best regards
Shong

Re: [resolved] ((Integer)globalMap.get("tMSSqlOutput_2_NB_LINE_INSERTED"))

Anonymous — Tue, 27 Oct 2015 20:47:36 GMT

now I have the following main job:

and 2 subjobs :

but I don't see the number of rows inserted or updated!!

Another ideas??

Thanks

Re: [resolved] ((Integer)globalMap.get("tMSSqlOutput_2_NB_LINE_INSERTED"))

Anonymous — Wed, 28 Oct 2015 13:35:51 GMT

Now I have the fillowing job:

the subjob:

But I have many error in the subjob:

Any ideas??
Thanks
Didier

Re: [resolved] ((Integer)globalMap.get("tMSSqlOutput_2_NB_LINE_INSERTED"))

Anonymous — Fri, 30 Oct 2015 07:12:49 GMT

Hi
The variable have to be used in the next subjob rather than child job, so change the job as seen below, you should be able to get the value of the global variable.
For example:
tFileFetch
|
onsubjobok
|
your main processing---tMssqlOutput_1
|
onsubjobok
|
tFixedFlowInput--main--tLogRow
on tFixedFlowInput, you get the number of lines which has been updated/inserted/deleted on tMssqlOutput, to do it: define one column called it nb_inserted, and set its values as:
((Integer)globalMap.get("tMSSqlOutput_1_NB_LINE_INSERTED"))
Regards
Shong

Re: [resolved] ((Integer)globalMap.get("tMSSqlOutput_2_NB_LINE_INSERTED"))

Anonymous — Fri, 30 Oct 2015 08:43:39 GMT

Thanks Shong
easier and it works!