A syntax error has occurred.

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

View solution in original post


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

Six 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

 

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

View solution in original post

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

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 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog