SQL escape special characters - need help

talendtester — Tue, 24 Jan 2017 02:06:44 GMT

I have a tTeradataInput component which I am trying to run more complex SQL.
Usually it runs fine but this time my SQL has single quotes, vertical pipes, plus signs, exclamations marks, equal signs
I am pretty sure the problem is the exclamations marks, how do I get Talend to ignore it and pass it to the database?
example:
AND t1.col1 != t2.col2
AND t2.col1 != t1.col1

Re: SQL escape special characters - need help

talendtester — Tue, 24 Jan 2017 02:47:29 GMT

This works:
AND t1.col1 <> t2.col2
AND t2.col1 <> t1.col1
Any ideas how to make != work?

topic SQL escape special characters - need help in Talend Studio

SQL escape special characters - need help

Re: SQL escape special characters - need help