Hi, I'm trying to run a script in tDBRow for Teradata that creates several volatile(temp) tables.
On my DB connection I already have MODE=TERA but i keep getting error messages
Only an ET or null statement is legal after a DDL Statement.
the script below is similar to what im trying to run, it works fine in TOAD and in Teradata SQL assistant, but not it Talend
create volatile table A as
(select * from table 1);
create volatile table B as
(select * from table A);
create table FINAL as
(select column1, column2 from table B);
I saw a similar question and someone pointed to this link, but i couldn't find anything that would help me, at least I didn't understand how to use it.
The tTeradataRow component is using jdbc driver , If you want to do it using teradata utilities like BTEQ, please have a look at tTereadataFastExport component which is able to export data from Teradata tables into flat files.
The tTeradataRow component is using jdbc driver , If you want to do it using teradata utilities like BTEQ, please have a look at tTereadataFastExport component which is able to export data from Teradata tables into flat files.
