Making System Calls in Stored Procedures

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."

Use the “system” command in the stored procedure.

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


Recent Articles: