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

[Anonymous]

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?

[Anonymous]

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

[max033]

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.