query error and strange syntax for Pervasive

BlueOctopus — Sat, 16 Nov 2024 05:24:37 GMT

Hi all,

I have a tDBInput, that connects to my basic table correctly and shows all related fields.

As an output I have just a FileOutputDelimited, with a mapping in between.

Whenever I execute the job, the query is returning me an error as shown below:

Exception in component tDBInput_1 (Venice_Account_Extract)
org.talend.components.api.exception.ComponentException: SQL_ERROR:{message=[Pervasive][ODBC Engine Interface]Syntax Error: SELECT
CLOVA.ACC.<< ??? >>"SysNum",
CLOVA.ACC."Crc_1",
CLOVA.ACC."Crc_2",
CLOVA.ACC."Crc_3",

Whatever I try to change in my basic query, or input, the first row always is receiving the strange replacement <<???>> in front of the first column name. Is this something that is known for Pervasive? How to overcome this issue? I'm completely stuck with this...

Can someone please help?

Re: query error and strange syntax for Pervasive

Anonymous — Tue, 02 Jul 2019 19:29:38 GMT

Hi,

Could you please try only with column names instead of using column names with multiple prefixes? Since you are providing the table name, you do not have to give the full prefix details for each column for a tDBInput component.

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 🙂

topic query error and strange syntax for Pervasive in Talend Studio

query error and strange syntax for Pervasive

Re: query error and strange syntax for Pervasive