Subscribing to a Topic

Sybase WorkSpace allows messaging constructs to receive messages from a published topic to which it subscribes in a JMS queue. Unlike sending and receiving a message, any authorized user can subscribe to a topic that has been published.

For a messaging construct to subscribe to a topic from a JMS queue, you must have both TIBCO JMS and Adaptive Server Enterprise connection profiles running with Real-Time Messaging configured. A topic must be available in the TIBCO JMS server to serve as an endpoint, or destination, for the subscription.

For the appropriate ASE connection profile and database, select the appropriate procedural object.

Object	How to select
Stored procedure	Expand the Stored Procedures folder, right-click the stored procedure, and select Edit.
Trigger	Expand the Tables folder, expand the table, and then expand the Triggers folder. Right-click the trigger and select Edit.

In the Source page, place the cursor in the desired location within the SQL code, right-click and select Sybase_ASE_15.x > Real-Time Messaging Wizard .
You can also open the wizard from the ASE Real-Time Messaging Wizard icon on the toolbar.
If the Subscribe to a Topic function is not visible, expand the Real-Time Data Functions > Topic-Related Functions folders first.
Select Subscribe to a Topic and click Next.
Select a Subscription Name.
Read-only information about the subscription appears in the Subscription Information box. The Preview box displays the SQL code that the subscription generates.
Click Finish.
Note: Because ASE messaging constructs are functions, select appears before the messaging construct. You can also assign the messaging function to a local variable that has already been declared.

See the Adaptive Server Enterprise Messaging Services User's Guide for Real-Time Data Services for more information.