How can a CL program can be written based on some SQL query which gives some records.
If SQL query is giving some records as output then using SNDEMLMSG command, how can that CL program be written? SNDEMLMSG command will send an email to specific user based on SQL query's output if any thing comes in output for that SQL query. Then the SNDEMLMSG command will be triggered and it will send an email to intended user.
How to write that IF condition for above requirement?
Any approach for that logic will be much helpful.