topic Re: Talend context issue with special characters in Talend Studio

Talend context issue with special characters

Anonymous — Sat, 16 Nov 2024 04:14:55 GMT

Hey guys ,

So I have currently a particular context created where I have some encrypted data passing through it . Eg ‘ 8/‘}#< ‘

I am trying to use this context in my SQL(tera data db) where clause eg where customer_number= “+context.cust_no.

When I try to run the job, it fails because of the single quotes and the various types of brackets in the query .

I can’t use a replace function cause I have to make sure both the encrypted keys from the source and context are matching .

The errors I’ve been getting are regarding open parenthesis and single quotes .

What would be the best solution to work around this ?

Re: Talend context issue with special characters

Anonymous — Tue, 29 Oct 2019 07:57:43 GMT

Hello,

When you type the special characters in your SQL(tera data db) where clause query, is it able to run the job successfully?

Best regards

Sabrina

Re: Talend context issue with special characters

Anonymous — Tue, 29 Oct 2019 12:08:46 GMT

Hi Sabrina ,

No , when I hard code / type the customer number into the where clause instead of context , I get the same error .

Re: Talend context issue with special characters

Anonymous — Tue, 29 Oct 2019 14:07:57 GMT

Hi,

When you are adding escape characters to the current hard coded values, are they running fine?

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: Talend context issue with special characters

Anonymous — Tue, 29 Oct 2019 23:26:46 GMT

I can add escape sequences for single quotes , how would I add it in for 3 types of brackets ?

Re: Talend context issue with special characters

Anonymous — Wed, 30 Oct 2019 07:22:42 GMT

Hello,

Would you mind giving us an example about your single quotes and the various types of brackets in the query? Screenshots will be preferred.

Best regards

Sabrina