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.

Note: Messages containing multiple statements must follow the rules for batches, as described in the Transact-SQL Users Guide.

Sybmail includes these ESPs to process incoming messages:

xp_findnextmsg
xp_readmail
xp_deletemail

For complete syntax and parameters, see the Reference Manual: Procedures.

Find the Next Message
xp_findnextmsg returns the message identifier of the next message in the Adaptive Server inbox.
Read a Specific Message
You can read a specific message by passing its message identifier to xp_readmail.
Delete a Message
After reading Adaptive Server mail with xp_readmail, you can remove the message from the inbox by passing the message identifier to xp_deletemail.
Processing Incoming Mail
You can manually process Adaptive Server incoming e-mail queries.

Parent topic: E-mail Messages and Adaptive Server