Making System Calls in Stored Procedures

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.

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

Recent Articles: