Question:
I’m writing a procedure to send an e-mail that will receive two parameters: the e-mail address of the recipient and the subject of the e-mail (e-mail content is not needed). How do I send a command to the OS to send the e-mail?
I’m using Informix 7.3 on Sun Solaris 2.6. The command that I’m using in Unix to send emails is: “mailx -s ‘subject’ receipient_address < /dev/null."
Answer:
Use the “system” command in the stored procedure.