How to handle no rows retrieved from Mysql DB

[pravinm]

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. 

[Anonymous]

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

[pravinm]

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,

[Anonymous]

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