Unsubscribing from a Topic

Use the Real-Time Messaging wizard to unsubscribe from a subscription topic.

Unsubscribing from a topic follows a one-to-many model rather than a one-to-one model (as in receiving a message). To unsubscribe from a topic, you must have TIBCO JMS and Adaptive Server Enterprise connection profiles running with Real Time Messaging configured. A subscription from which to unsubscribe must be available. In addition, there must be topics from which you can unsubscribe and registered subscriptions for those topics.

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.
Select Topic-Related Functions > Unsubscribe From a Topic, and click Next.
Select the Subscription Name associated with the topic from which you want to unsubscribe.
Use Retain the Durable Subscriber to indicate whether you want to continue to subscribe to any durable subscription.
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.