topic Re: Does tDBRow output a populated NB_LINE_INSERTED value when executing a single SQL INSERT statement contained in a in Talend Studio

Does tDBRow output a populated NB_LINE_INSERTED value when executing a single SQL INSERT statement contained in a

Anonymous — Sat, 16 Nov 2024 05:02:31 GMT

Looking to see if NB_LINE_INSERTED is updated after a tDBRow executes an INSERT statement defined in the query in a schema column. If so, how do I access the value of NB_LINE_INSERTED?

Re: Does tDBRow output a populated NB_LINE_INSERTED value when executing a single SQL INSERT statement contained in a

Anonymous — Thu, 08 Aug 2019 03:07:34 GMT

Hi,

These parameters will be updated only after the transaction in that subjob is complete.

These parameters can be accessed from other Talend components by doing Cntrl+Space and then by selecting right parameters from drop down.

You can use them in components like tJava or Run if to do further processing like doing comparison based on your specific requirements.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved

Re: Does tDBRow output a populated NB_LINE_INSERTED value when executing a single SQL INSERT statement contained in a

max033 — Mon, 02 Mar 2020 09:39:48 GMT

Hi,

This NB line option is only available for Oracle Databases. Is there a similar alternative for other types of DB ? say postgres. Please let me know, thanks.