Route an empty recordset from tParseRecordSet

JayQueue — Wed, 09 Oct 2024 09:16:23 GMT

Hello,

There is a job with uses tDBSP with 3 IN params and then we parse the recordset with tParseRecordSet.
Now I want to catch what IN params do not return a record.

I thought it was easy with ((Integer)globalMap.get("tParseRecordSet_1_NB_LINE")) but this returns null.

Tried with a tMap to route with ((Integer)globalMap.get("tParseRecordSet_1_NB_LINE")) == null but this does not route anything.

Is there another way?

Re: Route an empty recordset from tParseRecordSet

JayQueue — Wed, 09 Oct 2024 10:26:55 GMT

Fixed it with

net.sourceforge.jtds.jdbc.CachedResultSet sfresultset = (net.sourceforge.jtds.jdbc.CachedResultSet) input_row.resultset; 
if (!sfresultset.next()) { 
    System.out.println("ResultSet is empty for " + input_row.fname + " " + globalMap.get("customerLastName")); 
} else { 
    System.out.println("ResultSet is not empty for " + input_row.fname); 
}

topic Route an empty recordset from tParseRecordSet in Talend Studio

Route an empty recordset from tParseRecordSet

Re: Route an empty recordset from tParseRecordSet