Sending Mail with tSendMail with tJava Condition

tmiles-vfpng — Tue, 26 Mar 2024 05:31:34 GMT

I would like to trigger an email when the sql executed returns null rows. However, triggering the email from tJava is proving troublesome.

Re: Sending Mail with tSendMail with tJava Condition

tmiles-vfpng — Wed, 03 Apr 2024 06:18:31 GMT

Solved the issue. Refer to the java code.

// Process rows

while (input_row != null)

{

if (input_row.TRNCNT > 1)

{

System.out.println("Systems OK!");

context.rowsProcessed = true;

return;

}

return;

}

// Check if any rows were processed

if (!context.rowsProcessed)

{

System.out.println("No Transactions");

globalMap.put("sendEmail", false);

return;

}