You are not logged in.
My data looks like:
The Teradata database SQL is converting the varchar to a date so it looks like:
cast(left( myDate, 4) || '-' ||
substr(myDate, 5,2) || '-' ||
substr(myDate,length(myDate) - 2 + 1, 2) as date ) as PULL_DATE
How can I get this SQL to run successfully in a tTeradataInput component?
The SQL runs fine outside of Talend.
The error message:
Exception in component tTeradataInput_3
com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata Database] [TeraJDBC 13.00.00.16] [Error 3706] [SQLState 42000] Syntax error: expected something between '(' and the 'left' keyword.
Do I need to somehow escape the word "left" or "cast"?
I have double quotes before and after the SQL. In my SQL I have single quotes.
Do I need to escape the vertical bars individually with "\\"?
Last edited by talendtester (2011-11-23 18:14:48)