• Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » Guess Query doesn't work when connection is based on context parameter

#1 2010-10-27 11:19:53

reiko
Member
Registered: 2010-07-07
Posts: 38

Guess Query doesn't work when connection is based on context parameter

Hi!
I am facing the problem that "guess query" is giving a wrong query when my connection is based on context.parameters.
Query with context paramters looks like this:

"\"SELECT \"+WK_2710_VT_ARTIKEL+\".wk_2710_SysID,
        \"+WK_2710_VT_ARTIKEL+\".wk_2710_Mand,
        \"+WK_2710_VT_ARTIKEL+\".wk_2710_Artikel, ...

query without context parameters but strings in the connection fields (HOST, USER ...):

"SELECT WK_2710_VT_ARTIKEL.wk_2710_SysID,
        WK_2710_VT_ARTIKEL.wk_2710_Mand,
        WK_2710_VT_ARTIKEL.wk_2710_Artikel, ...

How can this be fixed?

I am using TOS 4.0.2 and tAS400_Input as an Input component.

Thanks, Reiko

Offline

  • Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » Guess Query doesn't work when connection is based on context parameter

Board footer

Powered by FluxBB