Registering a Subscription

Sybase WorkSpace allows you to register a messaging construction as a subscription so that you and others can publish to and consume messages from a topic, and subscribe to or unsubscribe from a topic.

1. 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.

2. 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.

3. Select Real-Time Stored Procedures > Register a Subscription , and click Next.
4. Select a JMS Connection Profile.
   • If you do not have administrative rights to a JMS connection profile, choose an ASE JMS Provider Name to map the ASE provider to the JMS connection profile.
   • If you cannot make such a mapping, click Create to create a JMS connection profile.
5. Select the Topic name.
6. (Optional) Select Authenticate and enter the Name and Password if you want subscribers to validate their subscriptions.
7. Click Test Connection to ping the server and to verify that the connection profile is working.
8. Click Next.
9. Enter a Subscription Name.
10. Click Add to add a new selector; use Edit and Delete to edit or delete existing selectors.

    Selectors limit access to the subscription if the specified criteria are not met.

11. (Optional) Select Delivery Option to limit messages published to or consumed from a topic to a local or nonlocal subscription.

    The default is Local.

    Note: Do not select a delivery option if you want the subscription to be available to both local and nonlocal clients. To remove delivery restrictions, deselect Delivery Option.
12. (Optional) Select Durable if you want the properties and options to persist for the length of the subscription unless you alter it in the meantime.

    Enter a Durable Name and an identity for the client in the Client ID field.

13. 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.