topic How to execute multiple SQL statements using a single postgres input in Talend Studio

How to execute multiple SQL statements using a single postgres input

_AnonymousUser — Thu, 12 Sep 2013 13:17:20 GMT

Please tell me the way, How to execute multiple SQL statements using a single postgres input?

Re: How to execute multiple SQL statements using a single postgres input

Anonymous — Fri, 13 Sep 2013 03:06:50 GMT

Hi,
Please see the related KB article on Talend Help Center Executing multiple SQL statements with one tMysqlRow component.
Best regards
Sabrina

Re: How to execute multiple SQL statements using a single postgres input

Anonymous — Fri, 13 Sep 2013 07:27:11 GMT

In Talend exists no build-in component to do this job (except for MySQL because the MySQL server parse a statement always as script).
For this purpose I have created the component tSQLScriptParser.
http://www.talendforge.org/exchange/index.php?eid=724&product=tos&action=view
Usage: tSQLScriptParser -- (iterate) --> tPostgresqlRow (with the current SQL statement return value from tSQLScriptParser_1)
You have to decide if the tPostgresqlRow component create its own connection (and commits every statement) or use a separate connection to run the script within one transaction.