topic Get the count of records Upserted In tPostgresqlRow in Talend Studio

Get the count of records Upserted In tPostgresqlRow

Anonymous — Wed, 04 Nov 2015 17:27:02 GMT

Hi There,
Can any body help me out to get the count of records inserted or updated by the DML's written inside tPostgresqlRow component.
Like in tOracleRow we have an option to get the count out from the componet to use by talend variables.
Like that how can i do that thing in tPostgersqlRow.
If it's possible by changing code behind or by any procedure please guide me....
Exact Scenrio:
Insert into abc(a,b,c,d,e)
select * from d;
I want to know if i am executing this query in tPostgresqlRow how many records inserted to the target.
Like in tPostgresqlOutPut there are talend variables like _inserted,updated to furnish this operation.
Thanks!!!
Jyotiranjan

Re: Get the count of records Upserted In tPostgresqlRow

Anonymous — Fri, 06 Nov 2015 08:38:14 GMT

Hi,
There is no NB_LINE Global Variables in tPostgresqlRow.
In talend, tflowmeter and tflowmetercatcher components are used to log the flow of the process.
There is one column called "count" on the schema of tFlowMeterCatcher which counts the no. of records pass by the specify flow.
Best regards
Sabrina

Re: Get the count of records Upserted In tPostgresqlRow

Lorenzo5 — Thu, 07 Feb 2019 10:07:07 GMT

Hi @xdshi

I'm also very interested in this topic.

I would NOT capture the number of records inserted in a tPostgreSQLRow query like "INSERT INTO ... (SELECT * FROM..)" as an INTEGER, ready to be manipulated, but I would (at least) capture the PostgreSQL return message (a text message) such as:

"Query returned successfully: 198887 rows affected, 31.9 secs execution time."

Regards,

Lorenzo