multiple SQL queries

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
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

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch