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.
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 🙂
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 🙂
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 🙂
