topic Re: context variable doesn't show in tmap component in Talend 7.2 in Talend Studio

context variable doesn't show in tmap component in Talend 7.2

Anonymous — Fri, 27 Dec 2019 18:20:21 GMT

I have a issue to set up context variables in tmap component, screen shot as below, it will be much appreciate if someone can help.

Re: context variable doesn't show in tmap component in Talend 7.2

Anonymous — Fri, 03 Jan 2020 02:45:37 GMT

Hi
You are saying 'context variable does not show on tMap', however, you show a screenshot of tDBInput component, what is the issue?

Regards
Shong

Re: context variable doesn't show in tmap component in Talend 7.2

Anonymous — Fri, 03 Jan 2020 16:40:20 GMT

thank you for response,

I make other screen shot to show my question.

Re: context variable doesn't show in tmap component in Talend 7.2

Anonymous — Fri, 03 Jan 2020 16:43:39 GMT

as you see second screen shot, what I want is to use context.schema to replace the part I scratched, it mean to use context as variable to make sql flexible. so my job can connect to different database.

Re: context variable doesn't show in tmap component in Talend 7.2

Anonymous — Fri, 03 Jan 2020 17:53:23 GMT

Have you clicked the 'Guess query' button?

Re: context variable doesn't show in tmap component in Talend 7.2

Anonymous — Fri, 03 Jan 2020 18:15:19 GMT

yes, I did. but no luck.
by the way, this issue doesn't happen in version 7.1

thanks

Re: context variable doesn't show in tmap component in Talend 7.2

tnewbie — Mon, 06 Jan 2020 15:06:25 GMT

I guess you are inserting the context name within quotes which should be out of the quotes for the system to understand that it needs to be substituted with variable values...if you take care of the ones

marked in red your issue should be solved

Re: context variable doesn't show in tmap component in Talend 7.2

Anonymous — Mon, 06 Jan 2020 15:25:23 GMT

thank you for response,

I am able to insert context schema as variable in quote as you mention manually for sure, but it is not what I want,

what I want is to let Talend studio generate this quote automatically, which version 7.1 does.

so it is very useful when you run same job against different database, test, product db e,g.