topic Re: multiple rows in Talend Studio

multiple rows

Anonymous — Wed, 12 Jun 2013 10:10:42 GMT

Hi,
How to add multiple queries in tpostgresqlrow?
In tmysqlrow there is possibility like passing additionaljdbc parameters but in tpostgresqlrow i didnt find any option..
How to do it in tpostgresqlrow if there are multiple queries i need to write please let me know

Re: multiple rows

Anonymous — Wed, 12 Jun 2013 20:05:50 GMT

it is usually best to use multiple *Row components to issue separate queries rather than bundling them all in a single component. If you have a ton of queries to run, consider iterating over the queries by storing them in a file or db table.

Re: multiple rows

Anonymous — Thu, 13 Jun 2013 09:12:14 GMT

Hi,
Here is a KB article about Executing multiple SQL statements with one tMysqlRow component, hope it will be helpful for your job.
Best regards
Sabrina

Re: multiple rows

Anonymous — Thu, 13 Jun 2013 09:31:46 GMT

Hi Xdshi,
In tmysqlrow i can see advanced properties like allowmultiplequeries but for tpostgresqlrow it is not available?
Is there any way we can do same like as tmysqlrow which is shown in the link
( https://help.talend.com/search/all?query=Executing+multiple+SQL+statements+with+one+tMysqlRow+component&content-lang=en)

Re: multiple rows

Anonymous — Thu, 13 Jun 2013 09:59:06 GMT

Hi,
Would you mind opening a JIRA issue in the Talend DI project of the JIRA bugtracker for the requirement("Additional JDBC Parameters"). Our component developer will handle it.
Please paste the jira link on the forum so that other community users can get it, thanks for your contribution.
Best regards
Sabrina