Find number of rows returned from tMySQLRow

[Anonymous]

Hello,
I've noticed many variables produced from other components by way of getGlobal().
I'm wondering if it's possible to find the number of rows returned by a tMySQLRow or tMySQLInput?
Thank you
-Joe

[Anonymous]

Hi,
Talend has default global variables of processed row number for component(see my pic), the number of row is produced when the job are running, so you cannot set one by getGlobal() tSetGlobalVar.
Best regards
Sabrina

[Anonymous]

This doesn't seem to be the case when I run my job. I am able to get QUERY, however I am not able to get NB_LINE. See attached image.
my code from tFixedFlowInput:
context.iNextID
((Integer)globalMap.get("tMSsqlInput_1_NB_LINE"))
((String)globalMap.get("tMSSqlInput_1_QUERY"))

[Anonymous]

Looks like a typo, ((Integer)globalMap.get("tMSsqlInput_1_NB_LINE"))
^Capitalize Me

[Anonymous]

Genius!
Much appreciated jholman! Indeed that was the problem.

[Anonymous]

Hi jpetsche,
You can use an existing global variable or context variable in any component properties field. Press Ctrl+Space bar to display the full list of global and context variables used in various predefined Java functions. That way will avoid typo issue.
In addition, could you please mark this topic as"resolved"?
Best regards
Sabrina