topic PostgreSql update in Talend Studio

PostgreSql update

Anonymous — Fri, 16 Jun 2017 07:34:48 GMT

Hi All

how to write 'where' query in PostgreSQL output component

the query is 'update table_name set table2.enc_id=table1.enc_id where table1.filename =table2.filename & table1.practice=table2.practice;'

TRF — Fri, 16 Jun 2017 11:42:43 GMT

If you want to write plain SQL queries, use tPostgresqlRow component instead of tPostgresqlOutput

Anonymous — Sat, 17 Jun 2017 06:29:24 GMT

I checked these options .

now its working