Route an empty recordset from tParseRecordSet

[JayQueue]

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?

[JayQueue · Accepted solution]

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); 
}