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