A syntax error has occurred.

Five Stars

A syntax error has occurred.

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.

 


Accepted Solutions
Employee

Re: A syntax error has occurred.

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 :-)


All Replies
Employee

Re: A syntax error has occurred.

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 :-)

Five Stars

Re: A syntax error has occurred.

i,

 

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

 

Employee

Re: A syntax error has occurred.

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 :-)

Five Stars

Re: A syntax error has occurred.

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

15TH OCTOBER, COUNTY HALL, LONDON

Join us at the Community Lounge.

Register Now

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Why Companies Move to the Cloud: 7 Success Stories

Learn how and why companies are moving to the Cloud

Read Now