topic Re: How get table name in tmysqlinput in Talend Studio

How get table name in tmysqlinput

Anonymous — Tue, 18 Feb 2014 15:55:06 GMT

Hello,
I have a problem for retrieve a name of table in a tmysqlinput.
I try :
context.table = globalMap.get("tMysqlInput_3" + "_TABLE_NAME");
But context.table is null.
Have you an idea ?
Thank

Re: How get table name in tmysqlinput

Anonymous — Tue, 18 Feb 2014 20:42:22 GMT

The table name from the attribute does not matter. The only name what is real in use is the name of the table in the query. The query can be retrieved with:

context.query = (String) globalMap.get("tMysqlInput_1_QUERY");

I suggest you put the table at first in a context variable and use this var in your query.
The attribute TABLE you want to get is only in use for such things like Guess Query function.

Re: How get table name in tmysqlinput

Anonymous — Wed, 19 Feb 2014 09:19:46 GMT

Thank for answer,
However that doesn't work, the context.query is null..
I don't understand...

Re: How get table name in tmysqlinput

janhess — Wed, 19 Feb 2014 09:34:03 GMT

Did you change it to context.query = (String) globalMap.get("tMysqlInput_3_QUERY"); which seems to be your case?

Re: How get table name in tmysqlinput

Anonymous — Wed, 19 Feb 2014 15:51:55 GMT

Yes

Re: How get table name in tmysqlinput

Anonymous — Wed, 19 Feb 2014 16:02:29 GMT

I have try with other jobs but the var it's always null

Re: How get table name in tmysqlinput

Anonymous — Wed, 19 Feb 2014 16:18:28 GMT

Open your job and take a look at the source code. You will find a put to the global map with the query.
When do you read out the query? This query is - per definition - available at the end of the flow, meaning you should get the query from the globalmap in a next subjob e.g. with a tJava.

Re: How get table name in tmysqlinput

Anonymous — Thu, 20 Feb 2014 09:40:38 GMT

Thank for the answer,
It's work !
If i understand, i can retrieve the table name after execution ?
If it's that, it's a bad new, because i require the table name before execution of query. In fact i check the status of table, if it's good i launch the query, if not good exit.
is it possible to retrieve the table name at the beginning?