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

 

 

 

-----------

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.