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
Highlighted
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
Highlighted
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.
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)

 

 

 

-----------

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’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

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog