Database row component response

[cterenzi]

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.

[vapukov · Accepted solution]

sure direct answer - No 🙂

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

[cterenzi]

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.

[vapukov]

is it work slow?:

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