topic Re: How to call a database procedure for each row and continue to a tMap? in Talend Studio

How to call a database procedure for each row and continue to a tMap?

dstreun — Sat, 16 Nov 2024 02:57:44 GMT

Challenge: I have to call a database procedure before processing each row (insert/update). The procedure sets a context (security, valid-as-of-date etc.) which is used by an instead-of trigger. - How can I do this?

I tried with a component sequence of a tFlowToIterate, a tDBSP and a tMap with several tDBOutputs. But such a sequence does not seem to work. A tLogRow instead of a tDBOutput shows that all attributes are null. - Probably, because tDBSP does not pass the values from the input row to the output row...

Re: How to call a database procedure for each row and continue to a tMap?

manodwhb — Wed, 18 Mar 2020 03:29:38 GMT

Hi, you need to iterate records using tflwtoiterate and then you need to use tdbsp component to execute the procedure.

Re: How to call a database procedure for each row and continue to a tMap?

dstreun — Wed, 18 Mar 2020 07:04:09 GMT

That's what I did - see my description. Does not help!

Re: How to call a database procedure for each row and continue to a tMap?

dstreun — Wed, 18 Mar 2020 17:53:23 GMT

Finally, I found that I could use a tFixedFlowInput component to solve my issue.