One Star

How to run Multiple Teradata SQL Queries from a single component

Hi
I have a specific requirement to run multiple sql queries from a tTeradataRow or tTeradataInput component.
everytime I run I get following exception.
Only an ET or null statement is legal after a DDL Statement.
I tried putting ETBT statements nothing worked.
I read there is a way of dealing this issue is stored procedure. But tTeradata has no SP component like oracle. Can any one please help me in this.
Thanks,
Amit
3 REPLIES
Moderator

Re: How to run Multiple Teradata SQL Queries from a single component

Hi,
Have you already checked document TalendHelpCenter:Executing multiple SQL statements with one tMysqlRow component?
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 run Multiple Teradata SQL Queries from a single component

Thanks Sabrina,
But that does not work with teradata I am still getting the ET BT error message
for now I am just creating a table and then I am collecting stat on the fields of the newly created tables.
I checked JDBC Parameters for terdata I could not find any multi-statement or multi-query...
Thanks,
Amit
Moderator

Re: How to run Multiple Teradata SQL Queries from a single component

Hi,
So far, there is no tTeradataSP component. You can open a feature jira issue on Talend Bug Tracker, our component developer will check it.
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.