Database row component response

Ten Stars

Database row component response

Is there a way to retrieve database response messages when using a database row component (in my case, tPostgresqlRow) to do complex updates?  When I run the statement in a database session, I see a response like "UPDATE 0 420" and I'd like to be able to catch that when running the same statement in Talend.


Accepted Solutions
Forteen Stars

Re: Database row component response

sure direct answer - No :-)

 

but may be try to found other way? what are You try to do in database?

-----------

All Replies
Forteen Stars

Re: Database row component response

sure direct answer - No :-)

 

but may be try to found other way? what are You try to do in database?

-----------
Ten Stars

Re: Database row component response

I insert some data into a table and then create records in a mapping table where a mapping record does not exist. The SQL works fine in my dbRow component, but I was hoping to capture the response with number of rows inserted.

I could retrieve both tables and look for missing keys, but running it in the database takes seconds instead of minutes.
Highlighted
Forteen Stars

Re: Database row component response

is it work slow?:

 

 

SELECT count(*) as cnt FROM table1 WHERE NOT EXISTS (SELECT id FROM table2 WHERE table2.id != table1.id)

 

 

 

-----------

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Why Companies Move to the Cloud: 7 Success Stories

Learn how and why companies are moving to the Cloud

Read Now