Update query

[Hajar1]

Hello evryone, I have to correct a job in talend that do the update of a table, and it must be exactly like a similar job in DataStage, in the component that do the update in DataStage, I have the following query:

UPDATE DWADMIN.INV_INVOICE_LINES SET COMMERCIAL_RANGE=:4

WHERE ORIGINAL_INVOICE_ID=:1

    and ORIGINAL_INVOICE_LINE_ID=:2

    and INVOICE_HEADER_ID=:5

    and INVOICE_LINE_ID=:6

    and DWADMIN.INV_INVOICE_LINES.ORIGINAL_INVOICE_ID in 

           ( select DWADMIN.INV_INVOICE_HEADERS.ORIGINAL_INVOICE_ID

              from DWADMIN.INV_INVOICE_HEADERS

            where DWADMIN.INV_INVOICE_HEADERS.ORIGINAL_SET_OF_BOOK_ID =:3)

How can I do the same in Talend?

[Anonymous · Accepted solution]

@Hajar EL HADRI​ try the tDBRow component which is used to execute a query or use the tDBInput+tDBOutput components.

Regards

Shong