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
