Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
veryimportantdude
Contributor III
Contributor III
‎2010-11-16 08:20 AM

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
Labels (2)
Labels
241 Views
0 Likes
3 Replies
Anonymous
Not applicable
‎2010-11-24 11:15 PM

Yes, I want this too, would someone please help ??
241 Views
0 Likes
Anonymous
Not applicable
‎2010-11-25 09:47 AM

You can feed tPostgresRow with one full statement at a time, in an iterating loop ( fetching sql string from the files)...
241 Views
0 Likes
veryimportantdude
Contributor III
Contributor III
‎2011-01-20 03:27 AM
Author

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