topic Re: [resolved] How to update bridge table in Talend Studio

[resolved] How to update bridge table

Anonymous — Fri, 16 Sep 2016 13:30:29 GMT

Hi,
Mac OS El Capitan, TOS 6.1, Postgresql
How can i update a bridge table ?
update table
set colB = NewValue
where colA = value AND colB = OldValue;
Seems that this option can be found in Use field options.
How can i transmit those values for colB from tMap ??
Best regards,
Carlos

Re: [resolved] How to update bridge table

Anonymous — Mon, 19 Sep 2016 12:08:03 GMT

nobody for me ?
I want to transmit to the bdd output two different values for the same column to be able to make a set col = newvalue where col=oldvalue ?

Re: [resolved] How to update bridge table

Anonymous — Mon, 19 Sep 2016 12:19:45 GMT

You will need to use database "Row" component. In this component you can write your own update statement and populate the parameters as you wish (using Java String concatenation).

Re: [resolved] How to update bridge table

Anonymous — Tue, 20 Sep 2016 10:33:29 GMT

Thanks Richard.
Will test it asap.
Carlos