topic Re: How to handle no rows retrieved from Mysql DB in Talend Studio

How to handle no rows retrieved from Mysql DB

pravinm — Sat, 16 Nov 2024 05:03:53 GMT

Hi All,

How can I give different response when rows found and when zero rows found. below is my job.

I am able to get a response, but how can we respond when there are no rows.

Thanks.

Re: How to handle no rows retrieved from Mysql DB

Anonymous — Wed, 07 Aug 2019 04:49:20 GMT

Hi,

Could you please check using the parameters shown in the screenshot?

Please note that this value will be available after the operation. So you will have to split your operation to two subjobs. The first subjob should end with DBOutput Insert.

In the second subjob, you can use a tJava or Runif or similar component to check the condition and send the necessary response.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved

Re: How to handle no rows retrieved from Mysql DB

pravinm — Mon, 12 Aug 2019 06:40:42 GMT

This helps when there is a DML opperation, Can you a help me also on querying the records, I may or maynot get resultset.

How can I supply two different response on such situation.

Appreciate your help.

Thanks,

Re: How to handle no rows retrieved from Mysql DB

Anonymous — Mon, 12 Aug 2019 15:20:34 GMT

Hi,

For query operation, why don't you replicate your output result set to two operations using tReplicate Command? The first flow can be used to do aggregation (using tAggregateRow) where you can count the number of records passed from DB. The second flow will have original records.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved