Using the built-in functions msgsend and msgrecv, Transact-SQL applications can send messages to a queue or read messages from a queue in JMS and MQSeries.
A message body, or payload, can be constructed using application logic, or it can contain character or binary data directly from relational tables.
You can construct the values of message properties (header or user properties) from relational data or from application logic, and include the constructed message properties in the message that you are sending.
Messages read from the JMS or MQSeries queue can be processed by the application logic, or directly inserted into relational tables.To filter out only messages of interest when executing the read operation, specify a message selector.
Message properties in read messages can be individually processed by the application logic. For more information about message properties, see msgsend.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
