topic Re: Find number of rows returned from tMySQLRow in Talend Studio

Find number of rows returned from tMySQLRow

Anonymous — Wed, 26 Jun 2013 17:41:30 GMT

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

Re: Find number of rows returned from tMySQLRow

Anonymous — Thu, 27 Jun 2013 10:16:53 GMT

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

Re: Find number of rows returned from tMySQLRow

Anonymous — Fri, 13 Jun 2014 16:59:55 GMT

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"))

Re: Find number of rows returned from tMySQLRow

Anonymous — Fri, 13 Jun 2014 17:16:16 GMT

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

Re: Find number of rows returned from tMySQLRow

Anonymous — Thu, 26 Jun 2014 17:04:46 GMT

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

Re: Find number of rows returned from tMySQLRow

Anonymous — Fri, 27 Jun 2014 08:42:13 GMT

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