topic How to create teradata tables from a tMap component in Talend Studio

How to create teradata tables from a tMap component

Anonymous — Tue, 03 Feb 2015 13:59:44 GMT

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

Re: How to create teradata tables from a tMap component

Anonymous — Fri, 06 Feb 2015 03:48:34 GMT

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-jdbc.

Best regards
Sabrina

Re: How to create teradata tables from a tMap component

_AnonymousUser — Mon, 29 Jun 2015 14:55:17 GMT

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