Nine 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.

  • Data Integration
1 ACCEPTED SOLUTION

Accepted Solutions
Nine 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?

-----------
3 REPLIES
Nine 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?

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

 

 

 

-----------