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.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!