E-mail Messages and Adaptive Server
Adaptive Server can send and receive e-mail messages through Sybmail, the Sybase
messaging facility, and can also take advantage of Windows Mail.
- Sybmail Messages
Adaptive Server for Windows can send, receive, and process e-mail messages.
- Preparing Windows Mail for Sybmail
Sybmail uses Windows Mail facility, so you must prepare the Windows Mail system before you can use Sybmail.
- Create an Adaptive Server Login for Sybmail
After setting up an Adaptive Server profile in Windows Mail, create a login for Sybmail on Adaptive Server.
- Configuring Sybmail and Extended Stored Procedures
Adaptive Server uses XP Server, an Open Server application, to execute the system extended stored procedures (ESPs) that implement Sybmail.
- Manage a Mail Session
You must initiate an Adaptive Server mail session before any messages can be sent or received.
- Outgoing Messages
An outgoing message can consist of text or the formatted results of a query or batch of queries. You can send a message directly through isql from either a stored procedure or a trigger that uses xp_sendmail.
- Incoming Messages
Adaptive Server expects incoming e-mail messages to be in the form of Transact-SQL statements. Incoming mail can consist of a single statement or a batch of statements, delimited by an end-of-batch indicator.
- Sybmail Security
To prevent unauthorized users from accessing privileged Adaptive Server data through e-mail use the xp_sendmail or sp_processmail procedures to set the execution privileges on the ESPs that process mail and to set the security context for executing queries.
Created August 1, 2012. Send feedback on this help topic to Sybase Technical Publications:
pubs@sybase.com