Update query

Hajar1 — Tue, 19 Jul 2022 08:14:14 GMT

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?

Re: Update query

Anonymous — Tue, 19 Jul 2022 09:04:56 GMT

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

Regards

Shong

topic Re: Update query in Talend Studio

Update query

Re: Update query