Can't run script in Teradata

thiagoft — Fri, 15 Nov 2024 22:45:00 GMT

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.

https://community.talend.com/s/question/0D53p00007vCnoLCAS/call-teradata-bteq-scripts?language=en_US

Thanks in advance

Re: Can't run script in Teradata

Anonymous — Wed, 13 Jul 2022 08:06:39 GMT

Hello,

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.

https://help.talend.com/r/en-US/8.0/teradata/tteradatafastexport

Best regards

Sabrina

topic Can't run script in Teradata in Talend Studio

Can't run script in Teradata

Re: Can't run script in Teradata