topic Re: A syntax error has occurred. in Talend Studio

A syntax error has occurred.

vincent5 — Fri, 22 Feb 2019 07:03:42 GMT

Hello,

Our database is informix and because of this, we have components specific to this database.
My problem is the following, since a component "tELTInformixMap", I insert data in a table through the component "agELTInformixOutput". This is a simple query but is crashing on a problem of "Syntax error".
I execute this query directly in database and it works.
The problem is that I have no traces of the query that is translated by Talend, how can I add traces between these 2 components to verify that the query is correct.
Here are some screenshots and thanks for your help.

Re: A syntax error has occurred.

Anonymous — Fri, 22 Feb 2019 07:16:05 GMT

Hi,

I believe you are referring to the query mentioned in screen shot 2.

One of the reason could be that the context variable is not having right data.

Could you please print the full query in a tJava using System print function and verify whether the query looks the same?

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: A syntax error has occurred.

vincent5 — Fri, 22 Feb 2019 07:22:36 GMT

Yes, this is the query in screenshot 2.
How do I plug the Tjava after the agelTInformixOutput?
What is the code to display the query in the tjava?

Regards,

Vincent

Re: A syntax error has occurred.

Anonymous — Fri, 22 Feb 2019 08:12:55 GMT

Hi,

Please try like below in tJava. You do not have to print it after agelTInformixOutput.

I would say print the entire query and once its printed, copy and run to verify in Informix directly to check the syntax.

System.out.println("add your query here");

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: A syntax error has occurred.

vincent5 — Fri, 22 Feb 2019 08:25:03 GMT

Thank you very much, I should have thought about it but I never added tjava on a comoosant "informix".
Thanks again...