How to create teradata tables from a tMap component

One Star

How to create teradata tables from a tMap component

Hi everyone,
I am completly new in using talend and have som problems using the output component tTeradataOutput. While creating a new table ("create table if does not exist") with Action on data ("Insert") I get an Exception like this:
Only an ET or null statement is legal after a DDL Statement.
Although I filled in the DB Connection parameter "allowMultiQueries=true" an I set the Auto Commit Flag in my component tTeradataConnection.
Has anyone had the same problem and solved it already? The same job in Oracle works fine.
Thanks a lot and greets from Hamburg
Michael
Moderator

Re: How to create teradata tables from a tMap component

Hi Michael,

Could you please take a look at an article: http://forums.teradata.com/forum/extensibility/teradata-r-create-table-based-on-a-data-frame-using-j....

Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: How to create teradata tables from a tMap component

Michael,
I also have a same issue now.
Although I have no problem with Oracle, have the issue with Teradata DB when using DDL related option.
Have you fixed it ? 
Thanks in advance,
aki

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog