One Star

multiple SQL queries

Hello
I would like Talend to execute multiple sql queries for Postgres database.
tPostgresRow doesn't seem to work because of semicommas (Smiley Wink that separate statements.
Or if anyone has a suggestion how to write a bat procedure or anything to execute files that contain this sql statements. Multiple queries are stored in files on disk, each file contains 5-10 sql queries

any suggestions??
thanx
3 REPLIES
One Star

Re: multiple SQL queries

Yes, I want this too, would someone please help ??
Six Stars

Re: multiple SQL queries

You can feed tPostgresRow with one full statement at a time, in an iterating loop ( fetching sql string from the files)...
One Star

Re: multiple SQL queries

at the end i put them in a csv file and connected with iterate to t_postgresrow.it does the trick