Use of a tmap field in a query for tMsSqlInput

[INESBK]

Hi,

I would use a field that exist in tmap to use it with query in tMsSqlInput like this 

"select * from Table
where name="+row1.name

But when i run the job I get this error

Can you help me please ?

Thanks in advance.

[TRF]

Hi,
First, because the name column is a string, the exact syntax should be:
"select * from Table
where name='"+row1.name+"'"
Is it enough to solve your problem? Not sure but you have to share your job design for a better answer.

[INESBK]

Thank you for your replay but it doesn't solve the problem.

[TRF]

Now you have a new problem, it's a compilation error.

Click on "Code" tab and go to line 4103 to get the exact compilation error.

[TRF]

Also share tMap_3

[INESBK]

With error S connot be resolved to a variable ! 

[TRF]

It seems the error is not there. Move the mouse pointer on the little red rectangle in the right marging, a popup should give you the message

[INESBK]

[TRF]

OK, you cannot use S.name in the SQL query as it not a known field in this component.

Do you use "Reload each time" as the Lookup Model in tMap_3?

This is the way to do what you expect (I think so).

Refer to this document for details.

[INESBK]

In fact, my need is to compare the contents of each incoming file by the lines in the database through the name to lighten the memory...