topic Re: [resolved] the AFTER global variable for tMSSQLOutput returning NULL in Talend Studio

[resolved] the AFTER global variable for tMSSQLOutput returning NULL

Anonymous — Wed, 22 Apr 2015 10:38:51 GMT

Hi,
I have a job where I am inserting rows from a csv to a SQL table.
Although rows have been inserted in the table, the NB_LINE_INSERTED is returning NULL.
Am I doing something wrong?

Regards,
Namrata

Re: [resolved] the AFTER global variable for tMSSQLOutput returning NULL

Anonymous — Wed, 22 Apr 2015 10:58:57 GMT

This variable can be only available in the next subjob, for example:
.......main--tMssqlOutput
|
onsubjobok
|
tJava
on tJava:
int inserted_line=((Integer)globalMap.get("tMSSqlOutput_1_NB_LINE_INSERTED"));
System.out.println(inserted_line);
Best regards
Shong

Re: [resolved] the AFTER global variable for tMSSQLOutput returning NULL

Anonymous — Wed, 22 Apr 2015 10:59:53 GMT

Re: [resolved] the AFTER global variable for tMSSQLOutput returning NULL

Anonymous — Wed, 22 Apr 2015 13:44:41 GMT

Works like a charm!!
I can be certain I had tried it before and hadn't worked though
Thanks!!